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