Returning last number(time) in a row of cells
 

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.

Returning last number(time) in a row of cells
 

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.

Returning last number(time) in a row of cells
 

Third and last for tonight:
http://img188.imageshack.us/img188/21/nonamev.png
Micky


"מיכאל (מיקי) אבידן" wrote:

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.

Returning last number(time) in a row of cells
 

Micky: thank you the first one did it. I had thought the count function would
have added. thanx again. Doug

"מיכאל (מיקי) אבידן" wrote:

Third and last for tonight:
http://img188.imageshack.us/img188/21/nonamev.png
Micky


"מיכאל (מיקי) אבידן" wrote:

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.

Returning last number(time) in a row of cells
 

Here's another one...

=IF(COUNT(A4:J4),LOOKUP(1E100,A4:J4),"")

Format as Time or h:mm

--
Biff
Microsoft Excel MVP


"v1rt8" wrote in message
...
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.