Good day peeps,
I cant figure out what function to use to my scenario please help.
Say I have
Sheet1 (as my answer sheet) I need to identify the Max value and rate per month
Sheet2 (A col. are days, col D until col AY are corresponding water reading per half hour ) below my data ...
Sheet3 Search 2 (A col. are days, col D until col AY are corresponding rate per water reading per half hour) below my data...
What i want to achieve is to get the rate per water reading given the highest water reading per month.
I have accomplish it thru long method I wish to have it simplified.
My long method as follows:
field 1 to get the max value form sheet 2 i used =MAX(IF(TEXT(sheet2A:A,"MM")="01",sheet2D:AY)), success on this.
field 2 using vlook up, i got the specific date, 24-Jan-13, the value was at its highest BUT i have done that on each day given, very Jurassic of me.
field 3 should give the value 0.7568 using formula =IFERROR(MATCH($$,$:$,0)," "), i was able to find the no. column where it shows which is on column 26, then use vlookup again using this column reference.
I hope I have explained this enough to be understood,given the above premise.
Thanks in advance.
Sheet 1
A B C
Month Max value per mo. Value X
from Sheet 2 from Sheet 3
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I cant figure out what function to use to my scenario please help.
Say I have
Sheet1 (as my answer sheet) I need to identify the Max value and rate per month
Sheet2 (A col. are days, col D until col AY are corresponding water reading per half hour ) below my data ...
Sheet3 Search 2 (A col. are days, col D until col AY are corresponding rate per water reading per half hour) below my data...
What i want to achieve is to get the rate per water reading given the highest water reading per month.
I have accomplish it thru long method I wish to have it simplified.
My long method as follows:
field 1 to get the max value form sheet 2 i used =MAX(IF(TEXT(sheet2A:A,"MM")="01",sheet2D:AY)), success on this.
field 2 using vlook up, i got the specific date, 24-Jan-13, the value was at its highest BUT i have done that on each day given, very Jurassic of me.
field 3 should give the value 0.7568 using formula =IFERROR(MATCH($$,$:$,0)," "), i was able to find the no. column where it shows which is on column 26, then use vlookup again using this column reference.
I hope I have explained this enough to be understood,given the above premise.
Thanks in advance.
Sheet 1
A B C
Month Max value per mo. Value X
from Sheet 2 from Sheet 3
<colgroup><col><col><col><col><col><col><col></colgroup><tbody> </tbody> |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>