Max String Question

[#1]

Hi

Bit stuck with this one, was trying to get the Max Wave for a particular leasing Company

I had this formula so far but doesn't seem to be working any ideas ?

=Max(<[Leasing Company]=$(vLeaseCo),Wave)

Thanks

Sarah

[MarcoWedel]

=Max({$<[Leasing Company]={'$(vLeaseCo)'}>},Wave)

[#3]

Sorry just tried and it said error ') expected

[anbu1984 · Accepted solution]

If Wave is string, then use MaxString()

=Max({$<[Leasing Company]={'$(vLeaseCo)'}>}Wave)  --Removed comma before Wave

[#5]

if it is a string you will need the maxstring() function