Thread: [Solved] Timeline - loop through all dates between first and last given and add date to column if not found
View Single Post
 
Old 05-02-2016, 07:35 AM
carlos_cs carlos_cs is offline Windows 10 Office 2013
Novice
  
Join Date: May 2016
Posts: 6
carlos_cs is on a distinguished road
Default Timeline - loop through all dates between first and last given and add date to column if not found
what i have in columns A, B, C:


Date Hours Name
01/03/2016 8,0 John
02/03/2016 8,0 John
08/03/2016 7,5 John
08/03/2016 2,0 Charles
08/03/2016 2,0 William
10/03/2016 3,5 Charles
11/03/2016 3,7 Charles
14/03/2016 2,2 Charles
15/03/2016 8,0 John
16/03/2016 8,0 John

what i want in column A, B, C in another sheet:


Date Hours Name
01/03/2016 8,0 John
02/03/2016 8,0 John
03/03/2016 0,0 -
04/03/2016 0,0 -
05/03/2016 0,0 -
06/03/2016 0,0 -
07/03/2016 0,0 -
08/03/2016 7,5 John
08/03/2016 2,0 Charles
08/03/2016 2,0 William
09/03/2016 0,0 -
10/03/2016 3,5 Charles
11/03/2016 3,7 Charles
12/03/2016 0,0 -
13/03/2016 0,0 -
14/03/2016 2,2 Charles
15/03/2016 8,0 John
16/03/2016 8,0 John

It has to work with any given dates, hours and names!

Please help i really need this!
Last edited by carlos_cs; 05-02-2016 at 08:41 AM. Reason: Forgot to mention there could be more than one entry for a given date!!
Reply With Quote