Hi,
I am trying to max value a range, based on criteria for the range row, and everything I tried so far doesn't work, so your help will be greatly appreciated.
Ex:
Sheet1
A1:A200 = 02:00:00 AM, 03:00:00 AM, 04:00:00 AM, 05:00:00 AM...etc
B1:B200 = values
Sheet2
A1= 04:00:00 AM
B1=Sheet name (Sheet1)
C1= Max formula (=MAX(INDIRECT("'"&B1&"'!"&"B3:B200"))
I need the formula to max value to corespondent range.
If A1=02:00:00 AM, then the range for max values to be B1:B200
If A1=04:00:00 AM, then the range for max values to be B3:B200
....etc
It would really help to change only the value in A1 and the formula to work with the new range, according to the A1 criteria.
I only need to change the starting row of the range( B1, B2,...etc.
Can this be done in just one formula? I am trying to avoid using too many formulas to retrieve cell and column numbers.
Thank you in advance,
Stef.
I am trying to max value a range, based on criteria for the range row, and everything I tried so far doesn't work, so your help will be greatly appreciated.
Ex:
Sheet1
A1:A200 = 02:00:00 AM, 03:00:00 AM, 04:00:00 AM, 05:00:00 AM...etc
B1:B200 = values
Sheet2
A1= 04:00:00 AM
B1=Sheet name (Sheet1)
C1= Max formula (=MAX(INDIRECT("'"&B1&"'!"&"B3:B200"))
I need the formula to max value to corespondent range.
If A1=02:00:00 AM, then the range for max values to be B1:B200
If A1=04:00:00 AM, then the range for max values to be B3:B200
....etc
It would really help to change only the value in A1 and the formula to work with the new range, according to the A1 criteria.
I only need to change the starting row of the range( B1, B2,...etc.
Can this be done in just one formula? I am trying to avoid using too many formulas to retrieve cell and column numbers.
Thank you in advance,
Stef.