Filter table and use formula

[yulya (Yulya R)]

I have a table in excel, I need to filter the table by the column Type =“RM” ,

then stretch the formula =VLOOKUP(Sheet1!C6,Sheet2!A:B,2) so that the values ​​are filled in only for those where the type is RM.

Then remove the filter and continue working with the table to end up with such a table. Can you please tell me which functionality is better to use? using my example if possible. I’ve already tried using filter data table, but it didn’t work.
Book2.xlsx (10.3 KB)

[jack.chan]

can you try use this custom activity package

Excel Activities for Processing and Filtering - RPA Component | UiPath...

for filtering use : filter column by values activity
drag formula: drag formulas in 1 or more columns activity

[yulya (Yulya R)]

What is this library called in UiPath? To install it

[jack.chan]

excel activities for processing and filtering

[jack.chan]

Example excel

1. (Filter by RM) call filter column by values activity
   

   

2. (Drag formula) use excel application scope, call VBA function (download my attachment VBAFunction.txt)
   VBAFunction.txt (261 Bytes)

Result!

[yulya (Yulya R)]

thank you very much, but how now to clean the filter?

[jack.chan]

you mean remove the filter?

[yulya (Yulya R)]

Yes, remove filter

[jack.chan]

im sorry i didnt think of this feature, ill be sure to add it next time

for now you can call filter column by value and set filterCriteria = <> this means filter Type=not blank

this will show all the rows

[jack.chan]

or try this
call invoke VBA where function name = CleanFilter

(replace the old VBAFunction.txt)
VBAFunction.txt (450 Bytes)