Greetings,

I've tried it but isn't the result I was expecting

Hi,

Correct, data type is float. I found the answer with Phil, which don't use the CASE that I was using. Thanks for your time!

Sorry if I wasn't clear. I was looking for a query that shows only a single row with the MAX TOC value in the selected range. This code by Phil...

• This reply was modified 3 years, 10 months ago by  tripari.

Thanks a lot! This is exactly what I was looking for. Thanks for your time

Greetings,

No, I just want a single row with the highest TOC column value in the selected range.