Filter table and use formula

Help Robot
, ,
1

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

image
image423×553 6.78 KB

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.

image
image814×468 19.8 KB

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)

2

can you try use this custom activity package

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

3

What is this library called in UiPath? To install it

4

excel activities for processing and filtering

5

Example excel

image
image328×682 6.26 KB

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

    image
    image1256×320 15.2 KB

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

image

Result!
image

6

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

7

you mean remove the filter?

8

Yes, remove filter

9

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
image

this will show all the rows

10

or try this
call invoke VBA where function name = CleanFilter

image
image1174×496 30.5 KB

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

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.