Return the top 3 largest amounts in each category based on identifier

[StanLeakup]

Hi all,

Please see below for reference. I am trying to populate Column H with a formula that pulls the three largest amounts in Column C based on the four criterias in Column E. The result would look like $230, $81 and $11 for A, $988, $100 and $93 for B, etc. So rather than the twelve largest values from Column C, I am looking for the three largest values in Column C for each letter (A, B, C and D).

Thank you!


Top 3 largest amounts based on identifier.JPG

[PaulM100]

You need to set up your data a bit differently and use =LARGE(IF($E$2:E$20$="A",$C$2:$C$20),G2), array entered

[kvsrinivasamurthy]

In H2 then copy down

=AGGREGATE(14,6,($C$2:$C$14)*($E$2:$E$14=LOOKUP(INT((G2+2)/3),{1,2,3},{"A","B","C"})),1+MOD((G2-1),3))