I wonder if it is possible in Excel to group entries with some sort of "moving date range". Similar to the financial analysis moving average. The idea is to have groups of entries that are each within a range of 3 days.
Assume a list:
1.10 x
2.10 zz
3.10 yy
3.10 mm
4.10 rr
5.10 ww
6.10 ff
I want to have groups that look like this:
Group 1:
1.10 xy
2.10 zz
3.10 yy
3.10 mm
Group 2
2.10 zz
3.10 yy
3.10 mm
4.10 rr
Group 3:
3.10 yy
3.10 mm
4.10 rr
5.10 ww
Group 4:
4.10 rr
5.10 ww
6.10 ff
Is this possible in Excel? The goal is to make an analysis on similarities within each group.
If someone could help me with this, I would be very grateful!
Thank you very much! Fabio
