# Returning Top Values From Multiple Critera

1. ## Returning Top Values From Multiple Critera

All - hope all is well,

I was hoping someone could help me with the following problem. I have a very large spreadsheet (27k rows) that I would like to do the following:

Return the largest values for given 2 critera, without creating other columns where I separate different "Businesses" (Such as Joe in NY)

Example:

Name Area Balance
Joe NY 25000
Joe NY 26000
Joe NY 15000
Miriam NC 2350
Stacey FL 65223
Peter VT 154313
Todd CA 0
Todd CA 15
Todd CA 25
Todd CA 65
Stacey FL 9855
Stacey FL 9595
Peter VT 1
Peter VT 958469

Using the Large() function will return the largest accounts, but how can I return the top two largest for Joe NY, Stacey FL, (assuming there are100s for each)?

Any help is greatly appreciated..

2. ## Re: Returning Top Values From Multiple Critera

=LARGE(IF(A1:A100="Joe NY",B1:B100),1)

=LARGE(IF(A1:A100="Joe NY",B1:B100),2)

For largest and second larges account of Joe NY

confim each with CTRL+SHIFT+ENTER not just ENTER

3. ## Re: Returning Top Values From Multiple Critera

Ahh yes, control shift enter...thanks..

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1