| 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? |
| 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 | |||
Threaded Mode
