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

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.