Combine VLookup and MAX ?

  • Thread starter Thread starter Ayato
  • Start date Start date
A

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

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

HTH,
Nikos
 
Back
Top