Urgent! Help! duplicate MATCH
I have a column of numbers in which the same may be repeated (they were found
using the LARGE function from a larger list). In the next column I use MATCH
to find the position of each number in the larger list. but I get the same
number for the duplicate numbers. I want MATCH to find their corresponding
positions in the larger list. here is a sample list:
84.16666667 332
79.16666667 364
78.33333333 203
78.33333333 203
77.91666667 125
75.83333333 46
74.16666667 123
74.16666667 123
74.16666667 123
74.16666667 123
As you see, the last 4 numbers are the same, but in reality they belong to
different postions in a previous larger list. 123 is just the first position.
why is it repeating the same position for all others?
I want a formula to give me the corresponding positions of these in the
larger list.
Or, if you have any other solution.
Thanks anyone who answers.
|