The MAX value of certain type ?
 

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

The MAX value of certain type ?
 

=MAX(IF(vendor_range="y",salse_range,""))

array entered (Ctrl-Shift-Enter)

Jerry

Ayato wrote:

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

The MAX value of certain type ?
 

Hi Ayato,

=MAX(IF(A1:A7="Y",B1:B7))

Enter above formula as an array formula (with Ctrl + Shif + Enter

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements