Hello,

I need help. In attached picture, I have data in 3 columns A,B,C. I need help finding a way to group same values in column B into batches, then filter them out. Then i need to see that the dates are in sequence for each of the batches, however the position of the dates must still be in order of POS in column A.

In short, I need to find a way to to "filter" out the dates that are not in sequence for each of the different groups of ACC_ORG values in column B. I cant do it manually as there are almost 200,000 rows.

sheet1.JPG

I have been trying to solve it, already two days, but cant do it.