Hello excel ninjas,
I have struggled to understand the highlighted portion in the following formula, of course from Chandoo.org. Why can't the MAX portion work alone without being equal to C5:C17="Jamie")*ROW(C5:C17? I have struggled to find out. I will appreciate your assistance because I am still very knew to excel. There is a lot of basic stuff that I still need to learn. Thanks. =SUMPRODUCT((MAX((C5:C17="Jamie")*ROW(C5:C17))=(C5:C17="Jamie")*ROW(C5:C17))*1,E5:E17)
I have struggled to understand the highlighted portion in the following formula, of course from Chandoo.org. Why can't the MAX portion work alone without being equal to C5:C17="Jamie")*ROW(C5:C17? I have struggled to find out. I will appreciate your assistance because I am still very knew to excel. There is a lot of basic stuff that I still need to learn. Thanks. =SUMPRODUCT((MAX((C5:C17="Jamie")*ROW(C5:C17))=(C5:C17="Jamie")*ROW(C5:C17))*1,E5:E17)