Not understanding what should be a simple operation.
The filter wizard works great on text but on integers im stuck.
Read range from Excel ( col A / index 0 ), into a DT.
Values in Excel are formatted as whole number.
Trying to remove values >200.
As per output, no go.
Furthermore when I change the operator to contains and surround the value with quotes, ie “200” it removes the 200 from the dt, so im guessing the read range is stored in the dt as text ?