Create a filter like on Pivot Table

[kauser]

How can i create a filter like on Pivot table from below data to select specific table. i use filter tool with AND but didn't work 

A=12, B=QQ, C=W1, D=USD, E=Y, F= OLD

A	B	C	D	E	F
12	QQ	W1	USD	Y	OLD
21	QQ	W2	USD	Y	OLD
12	ER	W2	USD	Y	OLD
45	RE	W2	USD	Y	OLD
12	QQ	W1	USD	Y	OLD
12	RE	W2	USD	Y	OLD
12	QQ	W1	EUR	Y	OLD
54	ER	W2	USD	N	NEW

Thank you 

[alexnajm · Accepted solution]

Not sure I understand - are you asking to just Filter data? If so, a filter tool will do the trick, and OR looks like what you may be needing instead of AND: A=12 OR B=QQ OR etc.