Show in Z the last entry from A thru N

P

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
 
P

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
 
M

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

Phillycheese5

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