There are several ways to achieve that, - here are two:
http://img9.imageshack.us/img9/9398/nonamegi.png
Micky


"v1rt8" wrote:

Need some help with this one please;
Row A4 thru J4
A4 B4 C4 D4 E4 F4 G4 H4 I4 J4
12:00 15:00 16:00

I need to return to cell K4 the last number in the above row.
I do not know what formula to use. Any help would be greatly appreciated.