Show in Z the last entry from A thru N

[Phillycheese5]

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]

Try

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

 

[Phillycheese5]

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

 

[Morrigan]

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.

 

[Aladin Akyurek]

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

 

[Aladin Akyurek]

Change Y1 to N1

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

 

[Phillycheese5]

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