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 ,
(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