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
Bookmarks