Good Afternoon
how would I go about doing the following
Do for each group; if the word Active is found in that grouping; set all of row H for that grouping to "Yes"
Groups shown below are 1, 2, 3, 4 - There could be many more groups
Ultimately, i'm looking to set the value Yes for each group that contains Active in the status field
Thanks
how would I go about doing the following
Do for each group; if the word Active is found in that grouping; set all of row H for that grouping to "Yes"
Groups shown below are 1, 2, 3, 4 - There could be many more groups
Ultimately, i'm looking to set the value Yes for each group that contains Active in the status field
Sheet1 | |||||||
# | Name | Status | Date | Checker | Group | Counted | Result |
1 | John | 1/1/2020 | Sally | 1 | Y | ||
1 | Joe | Active | 1/1/2021 | Sally | 1 | Y | |
1 | Sam | 1/1/2022 | Sally | 1 | Y | ||
2 | John | Active | 1/1/2020 | Sally | 2 | Y | |
2 | Joe | 1/1/2021 | Sally | 2 | Y | ||
2 | Sam | 1/1/2022 | Sally | 2 | Y | ||
3 | John | 1/1/2020 | Sally | 3 | Y | ||
3 | Joe | 1/1/2021 | Sally | 3 | Y | ||
3 | Sam | 1/1/2022 | Sally | 3 | Y | ||
4 | John | 1/1/2020 | Sally | 4 | Y | ||
4 | Joe | Active | 1/1/2021 | Sally | 4 | Y | |
4 | Sam | Active | 1/1/2022 | Sally | 4 | Y | |
4 | Kate | 1/1/2022 | Sally | 4 | Y |
Sheet1 updated | |||||||
# | Name | Status | Date | Checker | Group | Counted | Result |
1 | John | 1/1/2020 | Sally | 1 | Y | Yes | |
1 | Joe | Active | 1/1/2021 | Sally | 1 | Y | Yes |
1 | Sam | 1/1/2022 | Sally | 1 | Y | Yes | |
2 | John | Active | 1/1/2020 | Sally | 2 | Y | Yes |
2 | Joe | 1/1/2021 | Sally | 2 | Y | Yes | |
2 | Sam | 1/1/2022 | Sally | 2 | Y | Yes | |
3 | John | 1/1/2020 | Sally | 3 | Y | ||
3 | Joe | 1/1/2021 | Sally | 3 | Y | ||
3 | Sam | 1/1/2022 | Sally | 3 | Y | ||
4 | John | 1/1/2020 | Sally | 4 | Y | Yes | |
4 | Joe | Active | 1/1/2021 | Sally | 4 | Y | Yes |
4 | Sam | Active | 1/1/2022 | Sally | 4 | Y | Yes |
4 | Kate | 1/1/2022 | Sally | 4 | Y | Yes |
Thanks