How to use excel filtering to hide the correspondence instead of showing it

[goncalo.rocha]

Hello, i have an excel file where i am filtering a certain column for values equal to “RU10” but the filter shows me those values and what I need is that it Hides them instead, I’ve tried using the " != " but with no avail, can someone help me with this?

[supriya117 (Supriya Allada)]

Hi @goncalo.rocha

Instead of “!=” use “does not contain”

Give source as Excel.Sheet("E&O") No need to mention range.

[lrtetala (Lakshman Reddy)]

Hi @goncalo.rocha

In the Source you are giving Excel.Sheet[“E&O”].Range(“A2”) so it looks A2 only

Try this

Excel.Sheet[“E&O”].Range(“A:A”)