Hello, I would just like an explanation on what is going on behind the formulas I have set up. I wanted to set up a formula that would return the last row number in a given cell range. I used =MAX(ROW(A1:B3). however, this formula still returns the smallest row number (returns value of 1), in my specified range (A1:B3), even though I tried to use the MAX formula.
Why is it that, when I change my formula to =SUMPRODUCT(MAX(ROW(A1:B3))), it returns a value of 3? This is the right answer I need I just would like to understand why this is happening.
Greemo
edit: I am using Excel 2013
A | B | |
1 | ||
2 | ||
3 |
Why is it that, when I change my formula to =SUMPRODUCT(MAX(ROW(A1:B3))), it returns a value of 3? This is the right answer I need I just would like to understand why this is happening.
Greemo
edit: I am using Excel 2013