Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a row of data containing values that correspond to time values
(months) in each column. I need to select the month of the lowest value (just using the min function), but then need to determine the maximum value after the minimum value occurs. Is there a way to use the max function to accommodate a condition such as starting the range to evaluate in the cell after cell X (where cell X contains the minimum value)? I have 1000's of rows of data and would like to automate the process with a single formula, if possible. Any help is appreciated! Kiersten |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use IF function for two conditions | Excel Worksheet Functions | |||
How to use the IF Function for 3 conditions | Excel Worksheet Functions | |||
Max function with conditions | Excel Worksheet Functions | |||
If Function - two conditions? | Excel Discussion (Misc queries) | |||
Two Conditions Function | Excel Worksheet Functions |