Copy to Summarise data based on 2 criteria: User ID and gaps in continuous day segments for same user

[ayazgreat]

Is the answer:- that there is a break in days / missing days
4-Jan-22 ……… 6-Jan-22
7-Jan-22 …………………………… 2-Apr-22

Is the criteria for different rows in the results 2 things:
_a) Different Number
and also
_b) For the same number, if there is a break in days - in other words, for a valid Start date and End date pair in the results, there must be consecutive days in the rows in column C Data to which those Start date and End date pair refer.



Yes you are right regarding to above all answers