Hi
try the following array entered formula (entered with
CTRL+SHIFT+ENTER) to get the lowest available free number:
=MIN(IF(COUNTIF(A1:A1000,ROW(INDIRECT("1001:30000" )))=0,ROW
(INDIRECT("1001:30000"))))



-----Original Message-----
I want to check a range for available serial numbers.

The numbers run from 1001 and up, but as the cases close,
some might
become available again.

E.g. 1004 could be deleted from the range (becoming
available again)
while 1005 and so on is still taken...

How do I check the range "case" for lowest available
number starting at
1001, and return it as an integer?

Thanks


---
Message posted from http://www.ExcelForum.com/

.