Hi,

I have a list of six loans and some contain duplicate amounts. Column A is the Loan Name and Column B is the amount of the loan:

Loan XYZ, $300
Loan ABC, $300
Loan MNO, $200
Loan PQR, $250
Loan HIJ, $250
Loan 123, $100

How would I display the top five loans with its corresponding loan amount, regardless of the duplicate values, with an array formula? Would I have to assign, in Column C, a unique value for each row?

I used the following formulas to pull the loan amounts:
=LARGE($B$1:$B$6,COUNTIF($B$1:$B$6,MAX($B$1:$B$6))+0)
=LARGE($B$1:$B$6,COUNTIF($B$1:$B$6,MAX($B$1:$B$6))+1)
=LARGE($B$1:$B$6,COUNTIF($B$1:$B$6,MAX($B$1:$B$6))+2)
=LARGE($B$1:$B$6,COUNTIF($B$1:$B$6,MAX($B$1:$B$6))+3)
=LARGE($B$1:$B$6,COUNTIF($B$1:$B$6,MAX($B$1:$B$6))+4)

I used the following formula to pull the loan name:
=INDEX($A$1:$A$6,MATCH([Dollar Amount of Loan],$B$1:$B$6,0))

The result I keep getting, which I don't want, is this:
Loan XYZ, $300
Loan XYZ, $300
Loan PQR, $250
Loan PQR, $250
Loan MNO, $200

My intended result would look like this:
Loan XYZ, $300
Loan ABC, $300
Loan PQR, $250
Loan HIJ, $250
Loan MNO, $200

I hope this is clear and apologize if it's confusing. Any help would be so appreciated.


Thanks,