| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to convert date type to text type | Excel Discussion (Misc queries) | |||
| Excel will not let me type any characters....I can type in Word. | Excel Discussion (Misc queries) | |||
| Excel will not let me type any characters....I can type in Word. | Excel Discussion (Misc queries) | |||
| how to change all the words of one type(Gunsuh type)to another | Excel Discussion (Misc queries) | |||
| Adding new 'Type' to Format->Number->Time->Type | Excel Discussion (Misc queries) | |||
Linear Mode
