Excel filtering #N/A

[ashokkarale]

@0bb4628e217fd43ac86ac9294 ,

Try this.

After reading Excel, the NA values ​​on the control column come as less than zero, so you can filter as less than zero in the filter data table.It works this way

How to filter excel data table which contains #N/A values

Hello everyone, I have been trying to filter “#N/A” values using filter data table activity. I’ve tried “Column” = “#N/A” and “Column” Contains “#N/A” as shown below. All I can get is empty data table. Can anyone please help me? [na filter] Thanks in advance!

Thanks,
Ashok