G Guest Nov 26, 2003 #1 How can I find the right most cell containing a number in a row of cells containing numbers and blanks?
How can I find the right most cell containing a number in a row of cells containing numbers and blanks?
P Paul Nov 26, 2003 #2 Steve said: How can I find the right most cell containing a number in a row of cells Click to expand... containing numbers and blanks? The column number (in row 1) is given by either of these array-formulas: =MAX(IF(ISNUMBER($1:$1),COLUMN($1:$1))) =MAX(ISNUMBER($1:$1)*COLUMN($1:$1)) Remember to use CTRL+SHIFT+ENTER rather than just ENTER.
Steve said: How can I find the right most cell containing a number in a row of cells Click to expand... containing numbers and blanks? The column number (in row 1) is given by either of these array-formulas: =MAX(IF(ISNUMBER($1:$1),COLUMN($1:$1))) =MAX(ISNUMBER($1:$1)*COLUMN($1:$1)) Remember to use CTRL+SHIFT+ENTER rather than just ENTER.
