While filtering a column like Department Name, we can only filter the column for one name. Can we add operators like AND and OR so that we can look for two or more departments together?
Hi Monica Sihag,
When using the auto-filter, you can use || for OR and && for AND.
Thanks for the response IsaacI have tried using || and && in the filter section right above the department name and the filters on extreme right hand on the screen. Could you please help us with this?
Hi Isaac and Monica.
You can use || in substitution for the OR operator. That means, if you have a column with different department names you can type i.e: Finance || HR in the search box right below Department Name and only those rows that contain either Finance or HR will be returned. If you use && you will need to have cells in which both Finance and HR appear in that column so that it filters.
Thank you Andrés. It is working now.
Retrieving data ...