Skip to main content
Question

AutoFilter excel columns with multiple Criteria.

  • February 21, 2023
  • 2 replies
  • 226 views

Forum|alt.badge.img+2

Hi,

I wanted to auto-filter the excel columns with multiple criteria since there is no auto filter in excel advanced package,

can someone help me to do the following activity

Best Regards,

Sridhar

2 replies

Padmakumar
Forum|alt.badge.img+13
  • Navigator | Tier 3
  • 785 replies
  • February 21, 2023

Hi @Sridhar 4582 ,

 

There is a Sort Table option in the Excel Advanced package in which sorting option available with respect to a particular Column. 

 

You can use the Database package along with the ORDERBY keyword with multiple column names separated with comma.


Forum|alt.badge.img+2
  • Author
  • Cadet | Tier 2
  • 5 replies
  • February 22, 2023

Thank you for the response  @Padmakumar 

Since I don’t have any tables in my excel, so I need Auto Filter which has to work without even having tables in excel.

 

I wrote VB scripting for that, unfortunately, that was not working.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings