JoaoGabriel
New Member
- Joined
- Jun 6, 2021
- Messages
- 15
- Office Version
- 2019
- Platform
- Windows
fill with 1 or 0 with one condition:
- 1 when there are consumption values greater than 10 in any interval of three subsequent months, within the twelve months analyzed;
- 0 when it doesn't
apply the same for any subsequent four and six months
the data looks like this and the columns created on the side must be filled with 1 or 0:
can anyone help?
- 1 when there are consumption values greater than 10 in any interval of three subsequent months, within the twelve months analyzed;
- 0 when it doesn't
apply the same for any subsequent four and six months
the data looks like this and the columns created on the side must be filled with 1 or 0:
CONSUMPTION PER MONTH | ||||||||||||||||
ID | 2020/03 | 2020/04 | 2020/05 | 2020/06 | 2020/07 | 2020/08 | 2020/09 | 2020/10 | 2020/11 | 2020/12 | 2021/01 | 2021/02 | > 10 IN 3 SUBSEQUENT MONTHS | > 10 IN 4 SUBSEQUENT MONTHS | > 10 IN 6 SUBSEQUENT MONTHS | |
12414134 | 5 | 3 | 4 | 2 | 2 | |||||||||||
2312414 | 7 | 5 | 4 | 7 | 4 | |||||||||||
21431523 | 9 | 4 | 11 | 12 | ||||||||||||
1221415 | 2 | 8 | ||||||||||||||
5730110 | 89 | |||||||||||||||
4284205 | 12 | 16 | 10 | 0 | ||||||||||||
2838300 | 10 | 4 |
can anyone help?