Hi everyone, i need help regarding the formula i try to use, i use 3 columns, Date, Activity and Validity. Validity should be set to 1 at the end of the last same date if and only if there is atleast 1 Service each date, see example below
tried to use countif but if the first activity of the day is not Service, the validity wont be set to 1.
date | activity | validity |
1-Oct | Deliver | |
1-Oct | Service | |
1-Oct | Service | 1 |
2-Oct | Pickup | |
2-Oct | Deliver | |
3-Oct | Service | 1 |
4-Oct | Service | 1 |
tried to use countif but if the first activity of the day is not Service, the validity wont be set to 1.