#NAME Error on a MAX with multiple variables

[suds4333]

I have tried 2 different ways to find the Max value in a column based on 2 variables. You can see in example 2, I even tried to hard code the variable name instead of using the cell reference just to make sure it was not an issue with my validate fields in A@ and G2.

=MAX((Data!$U$2:$U$130599=$G2)*(Data!$E$2:$E$130599=$A$2),Data!$L$2:$L$130599)

=MAX(IF((Data!$E$2:$E$130599="Atlanta")*(Data!$U$2:$U$130599="All Towing & Recovery"),Data!$L$2:$L$130599))

Thanks for your help

Greg

 

[pgc01]

Hi Greg
Welcome to the board

Did you check that there is no Name error values in columns E,U,L?

 

[suds4333]

That was the problem! someone entered in column E a name that started with something excel thought was a formula

Thanks!

Hi Greg
Welcome to the board

Did you check that there is no Name error values in columns E,U,L?

 

[pgc01]

You're welcome. Thanks for the feedback.