But you said 10 would return 4, 5 would return 7. You could not get 7 for 5
unless you knew there was a 5 there.

--

HTH

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


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


--
Natalie


"Bob Phillips" wrote:

=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