Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a data set that looks like this starting at A1
name accounts sales dave 21 2000 bob 12 800 mike 8 375 chris 20 850 john 25 1900 brad 21 2800 To find the name that has the largest number of accounts I use a formula like this -- index(a2:c7,match(large(b2:b7,1),b2:b7,0),1) To get the 2nd largest I just change the value in the large function to (b2:b7,2). The problem is that there are two people with 21 accounts so the large function is getting stuck. I'd like the modify the formula so that sales is used as a secondary filter so that if the number of accounts is equal then sales is the deciding number with higher sales being better. This has to be pretty easy, but I can't figure out how to get sales to be the tie-breaker so to speak. Help Excel masters! Ted |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Not Lookup | Excel Worksheet Functions | |||
Lookup Problem | Excel Worksheet Functions | |||
lookup or table, not sure what to do | Excel Worksheet Functions | |||
lookup with 2 criteria | Excel Discussion (Misc queries) | |||
lookup help with multiple hits | Excel Worksheet Functions |