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
Bookmarks