I need to identify and remove all accounts that have GGGG as their code. Some accounts have multiple lines and the master report is over 5,000 rows. I have performed conditional formatting to find all the GGGG (this was the easy part). I want to delete all rows for the acct that has GGGG. How can I highlight all rows for the GGGG accounts?
ex: Act 111 has GGGG with a total of 3 rows, all 3 rows need to be removed. How can I quickly find and highlight all rows for an account that has GGGG?
ex: Act 111 has GGGG with a total of 3 rows, all 3 rows need to be removed. How can I quickly find and highlight all rows for an account that has GGGG?
Acct No | Order Date | Last | First | Code |
111 | 1/23/2020 | AAA | ZZZ | GGGG |
111 | 1/23/2020 | AAA | ZZZ | 01111 |
111 | 1/23/2020 | AAA | ZZZ | 01111 |
222 | 1/6/2020 | BBB | YYY | GGGG |
222 | 1/6/2020 | BBB | YYY | 00999 |
222 | 1/6/2020 | BBB | YYY | 00999 |
333 | 1/31/2020 | CCC | XXX | GGGG |
333 | 1/31/2020 | CCC | XXX | 01112 |
333 | 1/31/2020 | CCC | XXX | 01112 |
444 | 1/17/2020 | DDD | WWW | GGGG |
444 | 1/17/2020 | DDD | WWW | 09998 |
444 | 1/17/2020 | DDD | WWW | 09998 |
555 | 1/9/2020 | EEE | VVV | 09997 |
555 | 1/9/2020 | EEE | VVV | 09997 |
666 | 1/24/2020 | FFF | VVV | GGGG |
666 | 1/24/2020 | FFF | UUU | GGGG |
666 | 1/24/2020 | FFF | UUU | 01113 |
666 | 1/24/2020 | FFF | UUU | 01113 |
777 | 1/28/2020 | GGG | TTT | 01111 |
777 | 1/28/2020 | GGG | TTT | 01111 |
888 | 1/13/2020 | HHH | SSS | 00999 |
888 | 1/13/2020 | HHH | SSS | 00999 |
999 | 1/2/2020 | III | RRR | GGGG |
999 | 1/2/2020 | III | RRR | 09996 |
999 | 1/2/2020 | III | RRR | 09996 |