Hello,
I have 3 columns of cells. one has raw data in it. another has the numbers 1 thru 6 and the last has the formula below.
Essentially the cell with the formula (below), looks at the column of raw data and finds the nth highest (in this case 1st) and then displays the number (from 1 to 6) from the cell next to nth raw data cell.
Problem is when 2 or more cells have the same number it only displays the first match multiple times.
The formula I have used is:
=INDEX(AJ125:AJ148,MATCH(LARGE(AI125:AI148,1),AI125:AI148,0))
Is there a way to show the first nth match and then the next nth match (even know they are the same) in an order?
Cheers!!
Bookmarks