Fomula need to pick up last entry in a row

C

CJE

I know it is probably the easiest thing to do, but I can't figure it out.
I would like cell A1 to pickup the last entry in row 1, will be nuberical.
 
D

David Billigmeier

Is it actually the last entry in the ROW you are looking for? For example
you have cells B1, C1, D1, etc populated? If so the following formula
entered as array (CTRL+SHIFT+ENTER) will help:

=OFFSET($A$1,,MAX(IF(B1:IV1<>"",COLUMN(B1:IV1),""))-1)

OR, are you looking for the last entry in the COLUMN? For example you have
cells A2, A3, A4, etc populated? If so this formula will help (array entered
again):

=INDIRECT(CONCATENATE("A"&MAX(IF(A2:A1000<>"",ROW(A2:A1000),""))))

Do either of those help?
 
R

RagDyeR

Try this:

=LOOKUP(2,1/(1-ISBLANK(A2:A1000)),A2:A1000)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I know it is probably the easiest thing to do, but I can't figure it out.
I would like cell A1 to pickup the last entry in row 1, will be nuberical.
 
R

RagDyeR

Sorry, misread your post.

Try this:

=LOOKUP(2,1/(1-ISBLANK(B1:IV1)),B1:IV1)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Try this:

=LOOKUP(2,1/(1-ISBLANK(A2:A1000)),A2:A1000)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I know it is probably the easiest thing to do, but I can't figure it out.
I would like cell A1 to pickup the last entry in row 1, will be nuberical.
 
Top