TaskMaster
Board Regular
- Joined
- Oct 15, 2020
- Messages
- 58
- Office Version
- 365
- 2016
- Platform
- Windows
Good morning,
I was wondering if anyone can assist me with the following query.
I have a date range in column A for days of the year and column B shows values of 1 or 0. Is there a formula that I can use that would tell me the start and end of a sequence where it shows 1's.
For example the output for the table below would be start 01/01/2022 End 02/02/2022, start 09/01/2022 end 10/01/2022.
I was wondering if anyone can assist me with the following query.
I have a date range in column A for days of the year and column B shows values of 1 or 0. Is there a formula that I can use that would tell me the start and end of a sequence where it shows 1's.
For example the output for the table below would be start 01/01/2022 End 02/02/2022, start 09/01/2022 end 10/01/2022.
Date | Active | Start | End |
01/01/2022 | 1 | ||
02/01/2022 | 1 | ||
03/01/2022 | 0 | ||
04/01/2022 | 0 | ||
05/01/2022 | 0 | ||
06/01/2022 | 0 | ||
07/01/2022 | 0 | ||
08/01/2022 | 0 | ||
09/01/2022 | 1 | ||
10/01/2022 | 1 | ||
11/01/2022 | 0 | ||
12/01/2022 | 0 | ||
13/01/2022 | 0 | ||