Posted to microsoft.public.excel.programming

Ayato[_2_] Ayato[_2_] is offline

external usenet poster

Posts: 1

Combine VLookup and MAX ?

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

--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combine Vlookup and If?	Vicky	Excel Discussion (Misc queries)	1	August 17th 09 09:21 AM
combine Vlookup with the Right function	Harold Good	Excel Worksheet Functions	3	May 4th 07 04:10 PM
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP	buffgirl71	Excel Discussion (Misc queries)	12	November 14th 06 11:36 PM
How do I combine If and VLookup function?	Felicia Pickett	Excel Worksheet Functions	2	December 14th 05 12:06 AM
How to combine Vlookup and MAX ()????	Ayato	Excel Programming	1	December 2nd 03 01:57 AM

All times are GMT +1. The time now is 06:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us