Put this formula in K50...

=LOOKUP(2,1/(A1:A65535<""),A:A)

Rick


"old coach" wrote in message
...

data
A
1-41
2-19
3-12
4-80
5-36
numbers continue to be added in the column above.
If I add another number, I want it to be placed in another column i.e.
k50.
when i entered 12 in column A3 it also placed it in k50.
when i entered 80 in A4 it replaced the 12 in k50 with 80, etc.
how can i do this?




--
old coach