Fomula need to pick up last entry in a row
 

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.

Fomula need to pick up last entry in a row
 

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?
--
Regards,
Dave


"CJE" wrote:

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.

Fomula need to pick up last entry in a row
 

Try this:

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

--

HTH,

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

"CJE" wrote in message
...
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.

Fomula need to pick up last entry in a row
 

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!
================================================== ===

"RagDyeR" wrote in message
...
Try this:

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

--

HTH,

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

"CJE" wrote in message
...
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.