Clarification required on IFS() function

New Contributor

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.



0 Replies