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