Please help 🙂 Want to create a "New Date" column, see example below. Based on Date, and retain within ID&ID2, when marking is "Mark" See row 4 and 7 in example, where New Date is retain, only until cobination of ID&ID2 changes Row ID ID2 ID2_No Marking Date New Date 1 429857919 1 1 13-jun-17 13-jun-17 2 429857919 2 1 13-jun-17 13-jun-17 3 429857919 2 2 Mark 10-jul-17 10-jul-17 4 429857919 2 3 07-jul-17 10-jul-17 5 432852631 2 1 28-aug-17 28-aug-17 6 432852631 2 2 Mark 05-sep-17 05-sep-17 7 432852631 2 3 08-sep-17 05-sep-17 8 432852631 1 1 15-sep-17 15-sep-17 9 432852631 2 1 08-nov-17 08-nov-17 10 432852631 2 2 10-nov-17 10-nov-17
... View more