I need two columns.
If your unique number is in column A with no header row, then
In B1: =IF(MID(A12,3,1)="0",ROW())
In C1: =INDEX(A:A,MATCH(SMALL(B:B,ROW()),B:B,0))
Copy B1:C1 down
If you do not start in row 1, change the ROW() so that it yields a "1" in
the first row.
For example ROW()-4 if the data starts in row 5

Someone else might be able to combine these to columns, or maybe just try
what Dave just recommended.

"Gee" wrote in message
...
I have a db with 3000 records. Each record has a unique number that means
something. I want to return all the records that have 0 as the third
digit
eg., **0****. What formula do I need to enter to do this?

Thanks,
G