Need to Filter out the date

[sgaryali]

Hi,

I want to filter out the date which have two or more consecutive following date  in next row like:-

9/9/2022

9/10/2022

9/11/2022

I know we can use multi row formula tool to create some flag and use that column to filter out.

But I am not able to build the formula for Multi row tool.

Thank you in advance.

[DenisZ · Accepted solution]

Please see if this solves your issue

Please mark as solved if it solves the issue.

[ShankerV · Accepted solution]

Hi @sgaryali 

Could you please me the possible inputs and expected output.

So that can work on the solution as I was not able to get the complete information from the question.

Many thanks

Shanker V

[binu_acs · Accepted solution]

@sgaryali One way of doing this with the multirow formula by taking the DayTimeDifference of the two rows