Need Excel to generate a random unique static number based on a specific age division

[clark402]

Hi Excel Community,

I have a list of contestants in 6 different age divisions that I'd like Excel to automatically assign a unique random contestant number based on the age division which does not recalculate. Users won't know how to copy and paste a Randbetween output as values. So I'm looking for an alternative method to make the random number assignments static.

Also, new contestants are added during various registration dates so as new contestants are added to the bottom of the list, they will need a random number assigned without duplicating or changing previously assigned numbers.

Age Divisions	Unique Static (Non-recalculating) Random Numbers to Assignment
Junior	Randomly assign a unique number between 101 - 199
Intermediate	Randomly assign a unique number between 201 - 299
Senior	Randomly assign a unique number between 301 - 399
N-Jr.	Randomly assign a unique number between 2 - 30*
N-Int.	Randomly assign a unique number between 31 - 65
N-Sr.	Randomly assign a unique number between 66-99

*Bonus if you know how to make the assignment skip #13 for the superstitious contestants.

Attached is a sample from the contest scoring workbook.

Any help I receive is greatly appreciated.