With your list of products in Column E, starting at E2...

Bidder...

F2, copied down:

=INDEX($B$2:$B$7,MATCH(1,($A$2:$A$7=E2)*($C$2:$C$7=G2),0))

....confirmed with CONTROL+SHIFT+ENTER.

Amount...

G2, copied down:

=MAX(IF($A$2:$A$7=E2,$C$2:$C$7))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article <51147aa.0504051424.716fd642@posting.google.com>,
soapydux@gmail.com (Soapydux) wrote:

> Hi
>
> Looking to find a formula that will calculate a maximum bid figure
> from an array.
>
> Example data.
> Products Bidder Amount
> Product 1 John £50
> Product 2 David £50
> Product 1 William £55
> Product 1 Jill £45
> Product 3 Tom £60
> Product 3 Gwen £30
>
> So when I put s table together of all Product I get the highest
> bidders for each e.g.
>
> Products Bidder Amount
> Product 1 William £55
> Product 2 David £50
> Product 3 Tom £60
>
> Any ideas?
>
> Thanks