I have an excel which has some data i.e. rows and columns with headers but its not excel table.
I want to filter this data based on certain conditions like “NOT CONTAINS ABC” ANDALSO “NOT CONTAINS XYZ” and move to a different excel.
I tried using Filter Table but it needs 4 parameters i.e. Sheet Name, Table Name, Column Name and filter expression.
I am not sure can this be done without having Table Name. Any help will be appreciated.