Hi KSharp, Need a further help on the same. I need to retain rows where the diff is either 0,1 and also the row above. If you look at the table below, i would only want retain only the ones marked in blue or green (as, these are either similar days or Day+1). The one marked in red, is what i want to get rid of. (Basically, i just need to retain, if current row date is same as previous row or the date is +1 of the previous row) Name Date Seq_id Diff xyz 2-May-16 1 . xyz 2-May-16 2 0 def 23-Mar-16 1 . def 23-Mar-16 2 0 gef 7-Mar-16 1 . gef 7-Mar-16 2 0 gef 31-Mar-16 3 24 gef 1-Apr-16 4 1 gef 4-Apr-16 5 3 gef 11-May-16 6 37 gef 11-May-16 7 0 Thank you
... View more