I am wanting to generate the name (C8:C57) attached to the largest value in HF8:HF57. The below formula is working but when I adjust generate the 2nd largest and 3rd largest, it has problems if the values are duplicates.
Largest =INDEX($C$8:$C$57,MATCH(LARGE($HF$8:$HF$57,1),$HF$8:$HF$57,0))
2nd Largest = INDEX($C$8:$C$57,MATCH(LARGE($HF$8:$HF$57,2),$HF$8:$HF$57,0))
3rd Largest = INDEX($C$8:$C$57,MATCH(LARGE($HF$8:$HF$57,3),$HF$8:$HF$57,0))
As an example, the largest values are 3, 3, and 2. Any help to amend the formulas would be much appreciated.
Largest =INDEX($C$8:$C$57,MATCH(LARGE($HF$8:$HF$57,1),$HF$8:$HF$57,0))
2nd Largest = INDEX($C$8:$C$57,MATCH(LARGE($HF$8:$HF$57,2),$HF$8:$HF$57,0))
3rd Largest = INDEX($C$8:$C$57,MATCH(LARGE($HF$8:$HF$57,3),$HF$8:$HF$57,0))
As an example, the largest values are 3, 3, and 2. Any help to amend the formulas would be much appreciated.