Hello, I came across a formula that is built to return the last non-blank row number in a range.
The formula isFormula:Please Login or Register to view this content.
I am having trouble understanding how it works.
I understand that ROW(A2:A20) will return the value "2".
I understand that A2:A20<>"" SHOULD* return "TRUE" if there is at least one non-blank cell, and "FALSE" if all cells in the range are blank. (*See below).
I do not understand how TRUE * 2 or FALSE * 2 works, or how inserting that into a MAX function works. Isn't it only trying to max 1 singular number?
Lastly, I don't understand how the SUMPRODUCT formula brings this all together.
*Checking the "range not equal to blank" portion of the formula, I ran into the following issue. Any small-scale test I did yielded the expected results. However, I am trying to check an entire column, down to the end of the sheet, so there are many blank cells. Even though I have 65 non-blank cells, the function for some reason returns "FALSE" for when I check the entire range.
My formula is =H70:H1048576<>"" and returns "FALSE" even through H71:H135 are all filled with values.
Bookmarks