=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