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)


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
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,"?*")


--
Biff
Microsoft Excel MVP


"Debra Dalgleish" wrote in message
...
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