Stephen_IV
Well-known Member
- Joined
- Mar 17, 2003
- Messages
- 1,168
- Office Version
- 365
- 2019
- Platform
- Windows
I need a count that will tell me in any 30 day period starting with the first "x" if there are 4 or more x's in it. I have approx 60,000 rows of data. Thanks in advance!!!
8/30/2021 | 8/31/2021 | 9/1/2021 | 9/2/2021 | 9/3/2021 | 9/4/2021 | 9/5/2021 | 9/6/2021 | 9/7/2021 | 9/8/2021 | 9/9/2021 | 9/10/2021 | 9/11/2021 | 9/12/2021 | 9/13/2021 | 9/14/2021 | 9/15/2021 | 9/16/2021 | 9/17/2021 | 9/18/2021 | 9/19/2021 | 9/20/2021 | 9/21/2021 | 9/22/2021 | 9/23/2021 | 9/24/2021 | 9/25/2021 | 9/26/2021 | 9/27/2021 | 9/28/2021 | 9/29/2021 | 9/30/2021 | 10/1/2021 | 10/2/2021 | 10/3/2021 | 10/4/2021 | 10/5/2021 | 10/6/2021 | 10/7/2021 | 10/8/2021 | 10/9/2021 | 10/10/2021 | 10/11/2021 | 10/12/2021 | 10/13/2021 | 10/14/2021 | 10/15/2021 | 10/16/2021 | 10/17/2021 | 10/18/2021 | 10/19/2021 | 10/20/2021 | 10/21/2021 | 10/22/2021 | 10/23/2021 | 10/24/2021 | 10/25/2021 | 10/26/2021 | 10/27/2021 | 10/28/2021 | 10/29/2021 | 10/30/2021 | 10/31/2021 | 11/1/2021 | 11/2/2021 | 11/3/2021 | 11/4/2021 | Count |
x | x | x | x | x | x | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
8/30/2021 | 8/31/2021 | 9/1/2021 | 9/2/2021 | 9/3/2021 | 9/4/2021 | 9/5/2021 | 9/6/2021 | 9/7/2021 | 9/8/2021 | 9/9/2021 | 9/10/2021 | 9/11/2021 | 9/12/2021 | 9/13/2021 | 9/14/2021 | 9/15/2021 | 9/16/2021 | 9/17/2021 | 9/18/2021 | 9/19/2021 | 9/20/2021 | 9/21/2021 | 9/22/2021 | 9/23/2021 | 9/24/2021 | 9/25/2021 | 9/26/2021 | 9/27/2021 | 9/28/2021 | 9/29/2021 | 9/30/2021 | 10/1/2021 | 10/2/2021 | 10/3/2021 | 10/4/2021 | 10/5/2021 | 10/6/2021 | 10/7/2021 | 10/8/2021 | 10/9/2021 | 10/10/2021 | 10/11/2021 | 10/12/2021 | 10/13/2021 | 10/14/2021 | 10/15/2021 | 10/16/2021 | 10/17/2021 | 10/18/2021 | 10/19/2021 | 10/20/2021 | 10/21/2021 | 10/22/2021 | 10/23/2021 | 10/24/2021 | 10/25/2021 | 10/26/2021 | 10/27/2021 | 10/28/2021 | 10/29/2021 | 10/30/2021 | 10/31/2021 | 11/1/2021 | 11/2/2021 | 11/3/2021 | 11/4/2021 | count |
x | x | x | x | x | x | x | x | x | x | x | x | x | 2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Last edited by a moderator: