Thank you Debra. A bit complicated (for me) but works a treat!
--
Regards
Matt


"Debra Dalgleish" wrote:

There are instructions here for hiding used items in a data validation list:

http://www.contextures.com/xlDataVal03.html

Matt wrote:
I have a spreadsheet where I need to obtain a unique number from a
predetermined list for different entries on different rows (these rows are
not grouped together or in sequence). I need to pick this unique number
sequentially however I cannot use the same number twice. I have tried using
a data validation list however this allows the same number to be used
multiple times. Is there a method where the number can only be used once?


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com