CODEWITHSUNDEEP
excel
Sevenseer
Sevenseer

Reputation: 21

Finding the largest value

I have a worksheet which lists all the sales opportunities for our business. Each opportunity has the name of the group within the business, as well as the value, date, etc. I can use the LARGE function to find, for example, the three largest values in the worksheet, but how would I find the three largest values for each individual group? Would I need to set up a pivot table for each group and do it that way? Btw, I don't have access to VBA so rely must on Excel's standard functions.

Thank you for any help you can provide.

Upvotes: 1

Views: 58

Answers (1)

Dmitry Pavliv
Dmitry Pavliv

Reputation: 35843

Let your group names be in column A and values in column B, then you can use this array formula

=LARGE(IF(A:A="GROUP_NAME",B:B),1)

note that you should press CTRL+SHIFT+ENTER to evaluate it.

If you need second or third laargest value, than change 1 to 2 or 3. If you want to sum all this values, see @pnuts formula in comments below..

Upvotes: 1

Related Questions