How to find negative numbers contains in excel column

how to find negative numbers contains in excel column,Select filter

Are you working with dataTable, or directly with excel ?

@kalv,

Use Filter Data table activity to filter column.

Please find the below post:

with data table, i have tried this , Dt.Select("[column] LIKE ‘%-%’") but it will not work when all data is zero

Select return a DataRow (array of datarow) is it ok ?

Then dt.Select(“ColumnName < 0”) should work.
Or <= 0 if you want to include 0.

1 Like

i am working with excel

i have already tried this, its not working

I have tried this and work for me!

1 Like

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