Returning last number(time) in a row of cells

V

v1rt8

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

v1rt8

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

T. Valko

Here's another one...

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

Format as Time or h:mm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I ignore blank cells while averaging the solutions of equat 2
Problem with IF statements 1
Full page formulas 1
Leave final cell blank 2
Concatenate into 1 cell and drop down lines? 4
Formulate Entire Sheet 2
When IF has limited iterations 10
IF statement with 2 logicals 1

Top