Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding data between blank rows
A B
1 6:00 a 7:00 a 2 7:05 a 8:30 a 3 8:35 a 10:00 a 4 5 12:00 p 1:00 p 6 1:05 p 4:00p 7 8 6:00p 10:00p Each call-out will seperated by a blank row and, as shown above, can be made up of single or mutiple rows. There may be only 1 call-out or up to 5 in a day. I'm tring to find the start and stop times for each. Start End 9 1st 6:00a 10:00a 10 2nd 12:00p 2:00p 11 3rd 5:00p 7:00p Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FINDING THE FIRST ENTERED NUMBER IN A ROW OF DATA AFTER A BLANK CE | Excel Worksheet Functions | |||
How do I delete blank rows (rows alternate data, blank, data, etc | Excel Discussion (Misc queries) | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
Get number of rows that data takes up, including blank rows | Excel Worksheet Functions | |||
finding blank cell and moving specific data into it | Excel Worksheet Functions |