I'm trying to calculate the max number between 2 non blank cells in column A, using the values in column B when B>C. There are no blanks in B:B. C is always blank unless C>B.
IF(A2<>"";MAX(OFFSET(B2:C2;0;0;IFERROR(MATCH("*";OFFSET(A3;0;0;COUNTA(B:B)-ROW()+1);0);COUNTA(B:B)-ROW()+1)));"")
The above formula works on one sheet where I experiment with the calculation, but now that it works there, it doesn't on the real sheet I'm working on.
On the real worksheet, the formula is:
IF(A2<>"";MAX(OFFSET(H2:I2;0;0;IFERROR(MATCH("*";OFFSET(A3;0;0;COUNTA(H:H)-ROW()+1);0);COUNTA(H:H)-ROW()+1)));"")
Bookmarks