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 | W1 | USD | Y | OLD | |
21 | W2 | USD | Y | OLD | |
12 | ER | W2 | USD | Y | OLD |
45 | RE | W2 | USD | Y | OLD |
12 | W1 | USD | Y | OLD | |
12 | RE | W2 | USD | Y | OLD |
12 | W1 | EUR | Y | OLD | |
54 | ER | W2 | USD | N | NEW |
Thank you
Solved! Go to 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.