Show in Z the last entry from A thru N
 

I tried using the INDEX formula but I couldn't get it to work. I'm
trying to pull over to column Z the last number entry put into any
row...so it would look like this:
A B C ......... Z
1) 50 12 13 13
2) 10 10
3) 27 93 93

Any help would be appreciated.
Thanks,
Phillycheese5


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=388139

Try

=IF(COUNTA(A1:Y1)=0,"",INDIRECT(CHAR(COUNTA(A1:Y1) +64)&ROW()))




Phillycheese5 Wrote:
I tried using the INDEX formula but I couldn't get it to work. I'm
trying to pull over to column Z the last number entry put into any
row...so it would look like this:
A B C ......... Z
1) 50 12 13 13
2) 10 10
3) 27 93 93

Any help would be appreciated.
Thanks,
Phillycheese5


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=388139

The formula works for some cells but not others...it seems to be pulling
the last column in some cases and the second to last in others. Does it
matter if I have text in any of the cells to the far left (like in A and
B), and then sporadic blank cells?


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=388139

The above formula does not work if there are blank cells in between and
it will not work once you go pass Column Z (ie. Column AA)

I have not been able to come up with something that will suit your
application without filling the blank cell with 0. I bet vba can help
you tho.



Phillycheese5 Wrote:
The formula works for some cells but not others...it seems to be pulling
the last column in some cases and the second to last in others. Does it
matter if I have text in any of the cells to the far left (like in A and
B), and then sporadic blank cells?


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=388139

=LOOKUP(9.99999999999999E+307,A1:Y1)

Phillycheese5 wrote:
I tried using the INDEX formula but I couldn't get it to work. I'm
trying to pull over to column Z the last number entry put into any
row...so it would look like this:
A B C ......... Z
1) 50 12 13 13
2) 10 10
3) 27 93 93

Any help would be appreciated.
Thanks,
Phillycheese5

Change Y1 to N1

Aladin Akyurek wrote:
=LOOKUP(9.99999999999999E+307,A1:Y1)

Phillycheese5 wrote:

I tried using the INDEX formula but I couldn't get it to work. I'm
trying to pull over to column Z the last number entry put into any
row...so it would look like this:
A B C ......... Z
1) 50 12 13 13
2) 10 10
3) 27 93 93

Any help would be appreciated.
Thanks,
Phillycheese5

Aladin,
I don't quite understand why the formula works, but it handles the
issue.
Thanks,
Phillycheese5


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=388139