Sep 16 2020 09:55 AM
Hi -
Need one clarification.
Excel "Advanced filter" has a option using with i can filter out few selected columns only.
For example
Main datasheet has table with heading like
Name Phone email marital status Location Active
using advanced filter i can create a new data set using any or all the heading, suppose i need only Name and Phone number to be filtered at a different location, none of the other fields, then is it possible with "Advanced Filter"
My question is - do we have same flexibility with Filter() function too?
Please let me know if you have a answer or workaround for same.
Thanks in advance.