conditions and the max function
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 |
conditions and the max function
presuming you got no empty cells in the range C2:C100 try:
=MAX(INDIRECT("C"&MATCH(MIN(C2:C100),C2:C100,0)&": c100")) On 11 Gru, 16:07, kiersten wrote: 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 * |
All times are GMT +1. The time now is 11:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com