Combine VLookup and MAX ?

[Ayato]

Hi @ll,

I need a formula (or VBA code) that could help me to extract the MA
value for a specific identifer in a range.

For example:

I have vendors in column A and sales in column B

Vendor/Sales
a 50
a 53
a 90
b 110
b 36
a 100
c 500

I need to know the MAX for vendor a = 100, b = 110, c = 500

Please advise,
Ayat

 

[Nikos Yannacopoulos]

Ayato,

An easy way to do this is to sort on vendor, and then insert subtotals,
function Max.

HTH,
Nikos

 

[Peo Sjoblom]

One way

=MAX((A2:A11="a")*(B2:B11))

entered with ctrl plus shift & enter