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

[DocAElstein]

Hello
Thanks for the file and screenshot.
( You seem to have changed the format of column C ? I am not sure why you did that? It can be a bit confusing and irritating to someone trying to help you when you change things for no apparent reason. Perhaps you did not understand fully what I was asking for. I did not ask you to change anything in column C. So I am a bit confused. )

So we have learnt nothing about the date issue, because you changed the format in column C.

Question on you
Why did you change the format in column C?

You are continuing to make it very difficult to help you.

---

But let us try to move on……

You have given these 3 results for the Number 12345

12345 22 3-Jan-22 4-Jan-22
12345 22 6-Jan-22 7-Jan-22
12345 22 2-Apr-22 4-Apr-22


Questions for you to answer please

_(i) Why is this not the correct result?
12345 22 3-Jan-22 4-Apr-22

_(ii) Why is this not the correct result?
12345 22 3-Jan-22 7-Jan-22
12345 22 2-Apr-22 4-Apr-22

_(iii) Why is this not the correct result?
12345 22 3-Jan-22 4-Jan-22
12345 22 6-Jan-22 4-Apr-22


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.


Alan

[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