Tharabai
07-13-2015, 03:50 PM
Hi All, :hi::hi::hi:
Please!! required help !!
Step 1 : Filter not blanks column (column I) and find the difference in between the dates by inserting a column (column L) named "Difference"
Step 2 : Based on the value in the column "difference" i need to insert the rows and fill the values
eg. if the difference between the dates 01/13/2015 to 01/15/2015 is 3, then i need to insert 3 rows below this line and fill the dates with + 1 added to the dates till the end date and the ID should be the same.
01/13/2015
01/14/2015
01/15/2015
Column ID should be taken into consideration.
Let say ID is 12345 then dates are 01/13/2015 to 01/16/2015 then I need to insert below rows
12345 01/13/2015
12345 01/14/2015
12345 01/15/2015
12345 01/16/2015
Rows inserted should be highlighted
Step 3 : Concatenate ID and dates eg. 12345 01/13/2015
Step 4 : Compare for the column, if duplicated then, the row should be marked as “Overlap”
Step 5: delete the inserted rows (rows inserted to find the in between days)
Hope am clear with my requirement,
I have attached sample file for reference.
-Thara
Please!! required help !!
Step 1 : Filter not blanks column (column I) and find the difference in between the dates by inserting a column (column L) named "Difference"
Step 2 : Based on the value in the column "difference" i need to insert the rows and fill the values
eg. if the difference between the dates 01/13/2015 to 01/15/2015 is 3, then i need to insert 3 rows below this line and fill the dates with + 1 added to the dates till the end date and the ID should be the same.
01/13/2015
01/14/2015
01/15/2015
Column ID should be taken into consideration.
Let say ID is 12345 then dates are 01/13/2015 to 01/16/2015 then I need to insert below rows
12345 01/13/2015
12345 01/14/2015
12345 01/15/2015
12345 01/16/2015
Rows inserted should be highlighted
Step 3 : Concatenate ID and dates eg. 12345 01/13/2015
Step 4 : Compare for the column, if duplicated then, the row should be marked as “Overlap”
Step 5: delete the inserted rows (rows inserted to find the in between days)
Hope am clear with my requirement,
I have attached sample file for reference.
-Thara