"Natalie" wrote
I won't know that the number is necessarily 10.
Just that it is not equal to zero.

Just another guess

Assuming your list is in A1 down

Put in B1: =IF(A1<0,ROW(A1),"")
Copy B1 down until the last row of data in col A

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--