Mar 23 2017
06:40 AM
- last edited on
Jul 25 2018
09:29 AM
by
TechCommunityAP
Mar 23 2017
06:40 AM
- last edited on
Jul 25 2018
09:29 AM
by
TechCommunityAP
Hi,
I was using advance filter in Excel to select the data with multiple criteria, but i found that it works as "Begins with" not "Equal To"
Example:
If my Criteria has (1) Abacus (2) Computer (3) Automation (4) se
In the Data if i have any entries starrting with "Se" it will filter out..... it will filter even "seen" .
How can we tackle this issue in the advance filter.
Thanks,
Mar 23 2017 10:42 PM
HI Isra,
To filter just se, use below text in critera:-
="=se"
and advance filter option will only filter the exact text "se".
Regards,
DILIPandey
Mar 25 2017 02:33 AM
Hi Isra,
What Dilip mentioned shall work, check if you enter your criteria correctly