How to use the advance filter in MS Excel/MS Excel men advance filter ko kesy use krty hain.
#msexcel#Advancefilter# If you work with Excel, I am sure you have used (or at least heard about the regular excel filter). It quickly filters a data set based on selection, specified text, number or other such criteria.
You can use this when you need to use more complex criteria to filter your data set.
You can use Excel Advanced Filter to quickly extract unique records from a data set (or in other words remove duplicates).
you can use Excel Advanced Filter tool to quickly get a list of all the unique records in a different location (so that your original data remains intact).
Excel filters are great for seeing just a subset of your data. You can use filters for text, numbers, and dates, but also by color.