| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Calculation returning 19:00 | Excel Discussion (Misc queries) | |||
| Data entry for returning time | Excel Discussion (Misc queries) | |||
| Number Formating Cells (Time) | Excel Discussion (Misc queries) | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Linear Mode
