Hi, I want to create a formula which i can apply as a filter so i can limit my dataset to only show date where full weeeks are shown, could anybody help?
An example of the data sheet and how i want the filter to work:
<tbody>
</tbody>
An example of the data sheet and how i want the filter to work:
Date | Weeknumber | Filter | |
15-10-18 | 42 | 1 | |
16-10-18 | 42 | 1 | |
17-10-18 | 42 | 1 | |
18-10-18 | 42 | 1 | |
19-10-18 | 42 | 1 | |
20-10-18 | 42 | 1 | |
21-10-18 | 42 | 1 | |
22-10-18 | 43 | 0 | |
23-10-18 | 43 | 0 | |
<tbody>
</tbody>