Hi to ol, need help please, on what function to use in my spreadsheet.
what am working on sheet 1 is finding the max value per month from the data in sheet 2. of which i have use formula =MAX(IF(TEXT(Sheet2!A:A,"MM")="01",Sheet2!D:AY)), thank God success on this.
my prob is the value i had from this formula has a matching value on sheet3, what formula to use in order to get say value x, any chance i can upload my data here?
<colgroup><col><col></colgroup><tbody>
</tbody>
what am working on sheet 1 is finding the max value per month from the data in sheet 2. of which i have use formula =MAX(IF(TEXT(Sheet2!A:A,"MM")="01",Sheet2!D:AY)), thank God success on this.
my prob is the value i had from this formula has a matching value on sheet3, what formula to use in order to get say value x, any chance i can upload my data here?
<colgroup><col><col></colgroup><tbody>
</tbody>