Return highest value

Becky Wilson

I need to be able to create a formula that will return the highest value based:

I want it to match the Auction Item and return the highest value in the Bid column and the name of the highest bidder

In this instance, I want the result to be

Concealed Carry class - $100 - Becky Wilson

Lydia Gillis Photography - $500 - Becky Wilson

Find more posts tagged with

Formulas

Accepted answers

All comments

jodyh

Hi Becky,

I was able to do this using two additional columns- one for the math to determine the highest bid (MAX, COLLECT) and then one to list the Winner Name

For Highest Bid-

=MAX(COLLECT(Bid:Bid, [Auction Item]:[Auction Item], [Auction Item]@row))

For Winner Name-

=IF([Highest Bid]@row = Bid@row, Name@row, "")

Then convert to column formulas for both (and you can hide the Highest Bid column, since it's redundant).

Cheers!

Becky Wilson

Thanks. Is there a way to use the Max(Collect) in the Sheet Summary? I keep getting an Unparseable error when I try

Christina117

I too would love to know the formula to get the Winner Name in Sheet Summary.

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.