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.

Find more posts tagged with

Formulas

functionality

Accepted answers

Paul Newcome

Try a MAX/COLLECT

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

All comments

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...

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.