Hi Thanks for that.

That works to produce the max value per product i.e. Product 1 - £55
but I also need it to identify the highest bidder. Product 1 £55
William

Sorry if that wasn't clear enough before.

Cheers



"=?Utf-8?B?Um9uIENvZGVycmU=?=" <ronSKIPTHIScoderre@bigfoot.com> wrote in message news:<3CA0FBCB-0876-4F89-A902-D05F9F5970C3@microsoft.com>...
> 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