Using the LARGE, VLOOKUP, and IF functions, I am trying to sort determine the 3 largest values from a column with duplicate values. I'd like the function to find a subset in Col A and produce the first, second, and third largest values from the respective subset shown in Col B. Using the formula below, i'm able to find the largest value from each subset. Keep in mind that I have posted this in another sheet where $A2 is 144 etc.
I'd like to eventually write a macro to automate this process. Any help would be greatly appreciated.
=LARGE(IF(B2:B14<LARGEB2:B14,1),VLOOKUP($A2,$A$2:$B$14,4,FALSE),1),1)
<colgroup><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col></colgroup><tbody>
</tbody>
I'd like to eventually write a macro to automate this process. Any help would be greatly appreciated.
=LARGE(IF(B2:B14<LARGEB2:B14,1),VLOOKUP($A2,$A$2:$B$14,4,FALSE),1),1)
144 | 396.5887451 |
144 | 390.2167664 |
144 | 384.9399414 |
144 | 380.4719543 |
<colgroup><col><col></colgroup><tbody>
</tbody>
288 | 143.4509735 |
288 | 142.2271576 |
288 | 141.6318512 |
288 | 109.0777283 |
358 | 367.736084 |
358 | 364.7216797 |
358 | 363.9846497 |
358 | 363.8448792 |
358 | 363.1685486 |
358 | 362.6156311 |
<colgroup><col><col></colgroup><tbody>
</tbody>