Random name generator with no duplicates for company's lucky draw segment

I have 75 names to be included for my company's lucky draw segment.

How do I create an excel to generate a random name (winner), with no duplicates.

I've tried many options online but all of them will have duplicated names:
=INDEX($A:$A,RANDBETWEEN(1,COUNTA($A:$A)),1)
=INDEX(A:A,INT((RAND()*75)+1),1)
=OFFSET($A$1,ROUNDUP(RAND()*75,0),0,1,1)
=INDEX(A1:A75,INT(RAND()*75+1))
=RAND()
=INDEX($A$2:$A$76,RANK(B2,$B$2:$B$76))

Can anyone help to provide step by step solutions?
No vba or coding etc as I'm a Excel idiot.

Thank you.

List your names in one column. In a column next to it =RAND() and copy down. Select / highlight all cells in both columns.

With focus on the RAND column sort ascending or descending. The attempt to sort the RAND numbers will carry the names

next to them.

I think it would require Excel to memorize the numbers/names already generated, so if that number/name comes up again, it re-rolls the formula. 75 names is not a lot actually. You could use the formula, copy/paste the value for reference and in case the value comes up again, re-roll the formula manually.

I used a much simpler formula: =VLOOKUP(RANDBETWEEN(1;75);A1:B80;2;FALSE), where column A has numbers and column B has names.

Originally Posted by bmouse

I think it would require Excel to memorize the numbers/names already generated, so if that number/name comes up again, it re-rolls the formula. 75 names is not a lot actually. You could use the formula, copy/paste the value for reference and in case the value comes up again, re-roll the formula manually.

I used a much simpler formula: =VLOOKUP(RANDBETWEEN(1;75);A1:B80;2;FALSE), where column A has numbers and column B has names.

Good one. I'll have to remember it....and you're right.....it is much simpler.

I've tried your method and the names were still duplicated.

I can't afford to re-roll the formula manually actually but thanks for your help!

How many draws out of the 75 names are you planning to make? I'm not sure if this is significant, but perhaps it can spring a new idea of solving this.