Show multiple rows with filter?

[Lauren111111]

Hi,

for example, I have a table of data

Column a	column b
Yellow	pink
Blue	yellow
Green	purple
White	green

I want to see all the rows that contain yellow for example. But if I filter by column a, it won’t show the yellow in column b, and vice versa. Is there any way I can do this??

so it’ll end up looking like this:

column a	column b
Yellow	pink
Blue	yellow

 

[shaowu459]

Make helper column in column C, then filter column C with criteria not equal 0

MrExcel.xlsx
	A	B	C
1	ColumnA	ColumnB	Helper
2	Yellow	pink	1
3	Blue	yellow	1
4	Green	purple	0
5	White	green	0
Sheet6

Cell Formulas
Range	Formula
C2:C5	C2	=COUNTIF(A2:B2,"yellow")

 

[Lauren111111]

That works great, thankyou so much!

 

[shaowu459]

That works great, thankyou so much!

You are welcome