Excel randarray - create random number, duplicate number has same random number, no other duplication

In excel, I need to create random numbers that repeat when the number is in the list more than once.

So, 1 on the list would have the same random number, but this number would not repeat anywhere else on the list.

Sample date enter image description here

How it should look enter image description here

Thanks for your help

I have a data set of over 75,000 records some repeat up to 8 times and some are only on the list once.

How it should look enter image description here