Excell right cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I find the right most cell containing a number in a row of cells containing numbers and blanks?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Red cell for negative numbers in Excel 1
SUMIF with criteria "<>" & "=" 4
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Excel Conditional Formatting 1
#DIV error 2
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
count nonblank cells 3
How to reference last non-blank cell value from a column cells? 2

Back
Top