Obtaining Unique Number From Data Validation List

M

Matt

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?
 
T

T. Valko

You can save a few keystrokes in the dynamic range formula by replacing:

COUNTA('Employees - Original Formula'!$C$1:$C$6)-COUNTBLANK('Employees -
Original Formula'!$C$1:$C$6)

With:

COUNTIF('Employees - Original Formula'!$C$1:$C$6,"?*")
 
T

T. Valko

Even better:

You can replace:

COUNTA('Employees - Original Formula'!$C$1:$C$6)-COUNTBLANK('Employees -
Original Formula'!$C$1:$C$6)

With:

COUNT('Employees - Original Formula'!$B$1:$B$6)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top