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.
Hope this helps
Natalie Wrote:
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
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=480372