Filter Table Excel FilterOptions

Help Activities
,
1

Hi,

Any method to filter “different from” (<>) in the Excel Filter Table activity?

It is not relevant to use Filter Data Table in this case, as I need the info in the Excel sheet, just filtered away.

Thanks.

2

Hi @stch,
The easiest way i think is still to get alla the data in the excel and just use the FilterDataTable in Remove mode

image
image794×553 13.1 KB

3

I still the rows in Excel. Just filtered/hidden.

4

So the information have to be in the same Sheet, filtered but without loss of information, is that correct?

If so @stch you can just write/record a Macro for filtering and use the Execute Macro Activity

5

Correct, but a different workbook each run, but I guess macro is still possible.

Thanks.