In my worksheet in column CC in C1:C20 I want Excel to ganerate random numbers between 1 and 80 without repeating the same numbers.
At present I have the following formula entered and it works, but after I click F9 some repeated numbers are generated.
How can I change the formula or replace it?
Thank you in advance for your help.
Ragards to all supporters.