Numbering items from a list in order

Try

=IF(LARGE(A$1:A$9,ROW())>0,MATCH(LARGE(A$1:A$9,ROW()),A$1:A$9,0),"")

and formula-copy down to row 9

It will present the position required, but in descending sort order.


Assuming that column B was used, the numbers can be located by

=IF(B1<>"",OFFSET(A$1,B1-1,0),"")

- formula copy that down to row 9

It gives a sort-of correct response for duplicates, albeit from the wrong row.

Hope this helps

Originally Posted by Natalie

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