Excel

[Guest]

How do I find the right most cell containing a number in a row of cells

 

[Dave Peterson]

Worksheet function?

This will return the number of the column (I used row 1):
=MAX(ISNUMBER(1:1)*COLUMN(1:1))

This will return the address of the cell:
=ADDRESS(1,MAX(ISNUMBER(1:1)*COLUMN(1:1)))

For both of these formulas:
instead of just hitting enter, hit ctrl-shift-enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)