Fomula need to pick up last entry in a row

[Guest]

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.

 

[Guest]

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?

 

[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.

 

[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.