Ron:
Thanks for the formula for the Amount
What formula will bring back the corresponding
Bidder (Name) for the Max Amt?
Tks in advance...
Have a nice day.

>-----Original Message-----
>1)List your products from E1:E3
>
>2)Put this formula in Cell D1:
>=MAX(IF($A$2:$A$7=E1,$C$2:$C$7,0))
>(Note: Commit that array formula by pressing [Ctrl]+
[Shifr]+[Enter])
>
>3)Copy the formula into Cells D2 and D3
>
>I hope that helps.
>
>Regards,
>Ron
>.
>