I am stumbling to find the logic to match up these rows....
_____ Workbook: Data Sheet.xls ( Using Excel 2007 32 bit )
Worksheet: Sheet1
Row\Col A B C D E F G H I J K L M 1Date Channels start time New Time Other lines from From sheet2:- 2 11.15.2017 A NEWS 20:29:00 20:19:12A NEWS 15. Nov 17 20:19:12Mid Break-1 20:19:08 20:24:07 20 3 11.15.2017 A NEWS 20:59:00 20:21:20A NEWS 15. Nov 17 20:21:20Mid Break-1 20:19:08 20:24:07 20 4 11.15.2017 A NEWS 21:29:00 21:13:49A NEWS 15. Nov 17 21:13:49Mid Break-1 21:12:55 21:15:05 21 5 11.15.2017 A NEWS 21:59:00 21:36:30A NEWS 15. Nov 17 21:36:30Mid Break-2 21:35:31 21:40:14 21 6 11.15.2017 A NEWS 22:29:00 22:27:36A NEWS 15. Nov 17 22:27:36Mid Break-1 22:26:54 22:33:55 22 7 11.15.2017 A NEWS 22:59:00 22:48:51A NEWS 15. Nov 17 22:48:51Mid Break-2 22:47:02 22:54:02 22 8 11.15.2017 A NEWS 23:29:00 23:28:33A NEWS 15. Nov 17 23:28:33Mid Break-1 23:26:54 23:34:47 23 9 11.15.2017 A NEWS 23:58:00 23:29:55A NEWS 15. Nov 17 23:29:55Mid Break-1 23:26:54 23:34:47 23 10 11.16.2017 A NEWS 20:29:00 20:23:02A NEWS 16. Nov 17 20:23:02Mid Break-1 20:22:21 20:24:03 20 11 11.16.2017 A NEWS 20:59:00 20:50:04A NEWS 16. Nov 17 20:50:04Mid Break-3 20:46:06 20:53:37 20 12 11.16.2017 A NEWS 21:29:00
Testing
excelfox




Reply With Quote
Bookmarks