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..
Bookmarks