Deleting multiple rows based on criteria f

[KNM5800]

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?

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

 

[Fluff]

You could put a formula in the next column, then filter that for True & delete those rows

+Fluff New.xlsm
	A	B	C	D	E	F
1	Acct No	Order Date	Last	First	Code	Delete
2	111	1/23/2020	AAA	ZZZ	GGGG	TRUE
3	111	1/23/2020	AAA	ZZZ	1111	TRUE
4	111	1/23/2020	AAA	ZZZ	1111	TRUE
5	222	1/6/2020	BBB	YYY	GGGG	TRUE
6	222	1/6/2020	BBB	YYY	999	TRUE
7	222	1/6/2020	BBB	YYY	999	TRUE
8	333	1/31/2020	CCC	XXX	GGGG	TRUE
9	333	1/31/2020	CCC	XXX	1112	TRUE
10	333	1/31/2020	CCC	XXX	1112	TRUE
11	444	1/17/2020	DDD	WWW	GGGG	TRUE
12	444	1/17/2020	DDD	WWW	9998	TRUE
13	444	1/17/2020	DDD	WWW	9998	TRUE
14	555	1/9/2020	EEE	VVV	9997	FALSE
15	555	1/9/2020	EEE	VVV	9997	FALSE
16	666	1/24/2020	FFF	VVV	GGGG	TRUE
17	666	1/24/2020	FFF	UUU	GGGG	TRUE
18	666	1/24/2020	FFF	UUU	1113	TRUE
19	666	1/24/2020	FFF	UUU	1113	TRUE
20	777	1/28/2020	GGG	TTT	1111	FALSE
21	777	1/28/2020	GGG	TTT	1111	FALSE
22	888	1/13/2020	HHH	SSS	999	FALSE
23	888	1/13/2020	HHH	SSS	999	FALSE
24	999	1/2/2020	III	RRR	GGGG	TRUE
25	999	1/2/2020	III	RRR	9996	TRUE
26	999	1/2/2020	III	RRR	9996	TRUE
Result

Cell Formulas
Range	Formula
F2:F26	F2	=COUNTIFS(A:A,A2,E:E,"GGGG")>0

 

[KNM5800]

I tried plugging the formula you provided into the next adjacent cell. I am getting an error: =COUNTIFS(A:A,A2,E:E,"GGGG")>0

I know the basics of excel and can do some formatting and macros, but this has just got me. I'm sure it is a lot easier than I am making it. I want to make sure I understand your formula. A:A - is all column A, A2 - start looking here, E:E - all column E, "GGGG" - this is the "rule", >0 - greater than zero.
So, where column E = GGGG, define (TRUE) the matching rows in column A starting with A2?

 

[Fluff]

You may need to change the commas to semicolons, if that's what you normally use in your formulae.

 

[KNM5800]

I changed to semi colons and still with one error, (A:A;A2;E:E;"GGGG")>0
I appreciate your help.

 

[Fluff]

Try copying the minisheet from post#2 into a blank sheet in your workbook.
To copy it use the copy icon