Hi,
I have a problem in related to maxif and minif. I searched thru the forum and worked out a formula like this:
Worksheet 1 (WS1)
Column A: date, time (Hour, Min, seconds)
Column B: reaction time
Worksheet 2 (WS2)
Cell A1: 1/1/2015 6:00
Cell A2: 1/1/2015 7:00
Cell A3: 1/1/2015 8:00 etc...
My objective is to find the (Maximum reaction time- Min reaction time) that falls between 1/1/2015 6:00 AM to 1/1/2015 7:00 AM
For the max array: I tried the following but return with zero with all the entries???
WS2 Cell B1=MAX(IF((WS1 Column A>WS2 A1)*(WS1 Column A<=WS2 A2), WS1 Column B))
Does anyone know how to solve this problem??
Thanks
I have a problem in related to maxif and minif. I searched thru the forum and worked out a formula like this:
Worksheet 1 (WS1)
Column A: date, time (Hour, Min, seconds)
Column B: reaction time
Worksheet 2 (WS2)
Cell A1: 1/1/2015 6:00
Cell A2: 1/1/2015 7:00
Cell A3: 1/1/2015 8:00 etc...
My objective is to find the (Maximum reaction time- Min reaction time) that falls between 1/1/2015 6:00 AM to 1/1/2015 7:00 AM
For the max array: I tried the following but return with zero with all the entries???
WS2 Cell B1=MAX(IF((WS1 Column A>WS2 A1)*(WS1 Column A<=WS2 A2), WS1 Column B))
Does anyone know how to solve this problem??
Thanks