| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MAX IF? - Return MAX if Condition met in Separate Column
I need a formula that will return the MAX value in Column A if these
column A numbers have "Active" in column B. Column B is either Active or Inactive. Column A is age in days from 1-534. Is there such a thing as MAX IF? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MAX IF? - Return MAX if Condition met in Separate Column
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):
=MAX(IF(B1:B1000="Active",A1:A1000)) In article .com, wx4usa wrote: I need a formula that will return the MAX value in Column A if these column A numbers have "Active" in column B. Column B is either Active or Inactive. Column A is age in days from 1-534. Is there such a thing as MAX IF? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MAX IF? - Return MAX if Condition met in Separate Column
try
=MAX((A1:A100)*(B1:B100="Active")) entered with Cntrl+Shift+Enter or you'll get #VALUE "wx4usa" wrote: I need a formula that will return the MAX value in Column A if these column A numbers have "Active" in column B. Column B is either Active or Inactive. Column A is age in days from 1-534. Is there such a thing as MAX IF? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MAX IF? - Return MAX if Condition met in Separate Column
One way
=MAX(IF(B2:B100="Active",A2:A100)) entered with ctrl + shift & enter (lookup array formula in help) -- Regards, Peo Sjoblom "wx4usa" wrote in message oups.com... I need a formula that will return the MAX value in Column A if these column A numbers have "Active" in column B. Column B is either Active or Inactive. Column A is age in days from 1-534. Is there such a thing as MAX IF? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to separate sentences in a cell by using return | Excel Discussion (Misc queries) | |||
| Multiple Condition Text Return | Excel Worksheet Functions | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| Distribute info from "summary" page to separate pages under condition | Excel Worksheet Functions | |||
| FU: Distribute info from "summary" page to separate pages under condition | Excel Worksheet Functions | |||
Linear Mode
