I need to find a formula to caculate the MAX volumes of sales for a certain
vendor.
I have 2 columns "Vendors" & "Sales"

Vendor Sales

x 10000
x 9000
x 15000
y 8500
z 50000
y 9500
y 7500
I need to know the Max sales for vendor "y"

Any idea ?

regards,
Ayato