Skip to main content
Question

How to filter multiple values in excel

  • February 21, 2023
  • 6 replies
  • 890 views

Forum|alt.badge.img

How to filter multiple values in excel with automation anywhere ?

this documentation only show one value text option: https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-using-filter-table.html

and I have a problem with filter table 2 or more value, or any another way ?
 

6 replies

Forum|alt.badge.img
  • Cadet | Tier 2
  • November 18, 2023

I have the same problem, but looks AA cannot do this, they need to develop and release this function, they are still far behind of what UIPATH can do


Forum|alt.badge.img+1
  • Cadet | Tier 2
  • March 15, 2024

Hello there,

You can use Automation Anywhere to select the column where you want to apply the filter then Automate the process of specifying multiple values you want to filter. This might involve entering each value manually or reading values from an external source. Once the values are specified, use Automation Anywhere to apply the filter.

Hope this will be helpful.


Zaid Chougle
Navigator | Tier 3
Forum|alt.badge.img+17
  • Navigator | Tier 3
  • March 18, 2024

Hey @Romy 4794, for multiple filters you can use simulate keystrokes action inside excel sheet, inside advanced filters.

 


Forum|alt.badge.img
  • Cadet | Tier 2
  • March 26, 2024

Hello,

You can use run macros in an excel:

 

or

you can filter according to a range:

 

Hope this will be helpful.


AnsariRPA
Cadet | Tier 2
Forum|alt.badge.img+6
  • Cadet | Tier 2
  • May 18, 2025

Is there any fix for this yet?


Om Keskar
Navigator | Tier 3
Forum|alt.badge.img+6
  • Navigator | Tier 3
  • May 24, 2025

Hi,
Use the Run Macro action or use an Excel formula column for filtering logic.