Find 7 th Consecutive worked Day

Question

Hi all,

How to find if there are 7 consecutive working days in a Row.

111118/01Yes111118/02Yes111118/03No111118/04No111118/05yes111118/06Yes111118/07Yes111118/08Yes111118/09Yes111118/10Yes111118/11Yes111118/12Yes111118/13yes111118/14No111118/15No111118/16No111118/17Yes111118/18Yes111118/19No

Kindly help

Qiu · Answer

@dkma 
Batch macro should be a good match for this case.

0924-dkma.yxzp

apathetichell · Answer

Stylistically I don't ever use more than say 2 in the multi-row formula. I don't really know why.  I like a Tile tool approach/unique value approach.

the tile tool way.yxmd

jdunkerley79 · Answer

I would suggest:

First, parse the dates

You can then filter the days not worked

Then final sort into ID, Date ascending

Finally a multi-row formula tool can confirm that the last 7 days were all worked for an ID:

Have attached a quick sample

Worked 7 Days.yxmd