My Brain isn't working tonight.
I want to find the cell with the corresponding rank.
In the example below, I want to find the third highest ranked score in the range and place it's label in cell D1.
The result in D1 should be EEE.
In D2 I want the 2nd highest score. Result should be DDD
in D3 I want the higest score. Result should be CCC
(Desired Result in Bold)
I want to do this with an index formula with a nested ranking/match formula, but I don't know how to do it.
I'd like to do this without the MAX/MIN formulas.
Windows 7
Excel 2007
Thanks,
-Tony
<!-- Please do not remove this header --><!-- Table easily created from Excel with ASAP Utilities (ASAP Utilities for Excel - The popular add-in for Excel users. Easy to use tools that save time and speed up your work in Excel. We also offer a free edition.) -->
<tbody>
</tbody>
I want to find the cell with the corresponding rank.
In the example below, I want to find the third highest ranked score in the range and place it's label in cell D1.
The result in D1 should be EEE.
In D2 I want the 2nd highest score. Result should be DDD
in D3 I want the higest score. Result should be CCC
(Desired Result in Bold)
I want to do this with an index formula with a nested ranking/match formula, but I don't know how to do it.
I'd like to do this without the MAX/MIN formulas.
Windows 7
Excel 2007
Thanks,
-Tony
<!-- Please do not remove this header --><!-- Table easily created from Excel with ASAP Utilities (ASAP Utilities for Excel - The popular add-in for Excel users. Easy to use tools that save time and speed up your work in Excel. We also offer a free edition.) -->
AAA | 10 | 3rd | EEE |
BBB | 20 | 2nd | DDD |
CCC | 60 | 1st | CCC |
DDD | 50 | ||
EEE | 40 | ||
FFF | 30 |
<tbody>
</tbody>