How to get the max value in a column based from distinct values in another column

Michael Giovanni

Hi mates. Can you please help me to get the max value in a column based from distinct values in another column?

For example is like this

How to find the max value of "Car" based on the left table?

Please kindly help me, this is urgent.

Paul Newcome

Try a MAX/COLLECT

=MAX(COLLECT(Number:Number, Vehicles:Vehicles, "Car"))

Paul Newcome

Try a MAX/COLLECT

=MAX(COLLECT(Number:Number, Vehicles:Vehicles, "Car"))

Michael Giovanni

Can you please help me again to get the distinct list name of the vehicle? I really appreciate your help Paul!!!

Paul Newcome

I'm not sure I follow...