the max in column B for EVERYTHING (D,E,F,G, etc.) except "A,B,C" in Column L ?

[MIAO]

If I want to know the max in column B for EVERYTHING except the above listed palces "Unionville" "Oakville", "Thornhill" "Toronto" etc. in column L how would I go about doing that?


Thanks so much!

[daddylonglegs]

Can you clarify? are there numbers in column L or a list of places to exclude?

Generically you can use this formula

=MAX(IF(ISNA(MATCH(A1:A100,Z1:Z4,0)),B1:B100))

that will find the maximum value in B1:B100 associated with any value in A1:A100 except those listed in Z1:Z4. If you want you can include the locations in the formula like this

=MAX(IF(ISNA(MATCH(A1:A100,{"x","y","z","w"},0)),B1:B100))

either way formula needs to be confirmed with CTRL+SHIFT+ENTER

[MIAO]

you are FANTASTIC thanks!