I would like to apply multiple filters on a column simultaneously.
Below is my actual data and I would like to apply filter on name column to have only “ABC”,“DEF” and “PQR”.
The issue is only the last filter PQR is getting applied and others are getting removed. I tried using custom also but then only 2 filters can be applied at a time and not more than that.
image.png (2.5 KB)
Below is the output I require,
image.png (2.6 KB)
Can you please help here. Attaching excel for your reference.
Excel.zip (6.3 KB)