=MATCH(10,A1:A20,0)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Natalie" wrote in message
...
Does someone have a method for identifying a set of numbers by their
position
within in a list.
For example
0,0,0,10,0,0,5,0,2
If I want to identify all the items that are not equal to zero, by their
position
10 would return 4, 5 would return 7, and 2 would return 9
I need to identify every occurance.
--
Natalie