Excel filtering #N/A

[0bb4628e217fd43ac86ac9294 (Rpauipathr)]

Hi all,

I have a query.

I have two excels I have done vlookup and saving the vlookup data in excel1 under column D now I need to filter the columnD with #N/A values and store in DT.

I am using filter data table and gave condition column name =“#N/A” but it’s not working I am not getting the expected output as #N/A is a formula

Can anyone help me.

Thanks in advance

[hp321 (ap)]

Hi @0bb4628e217fd43ac86ac9294 ,
Please give this a try:
As you say, the column consists of “#N/A”, so add a condition to the existing filter. ex: And columnD-does not contain “Random”.

[hp321 (ap)]

this may help as well:

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!

[lrtetala (Lakshman Reddy)]

Hi @0bb4628e217fd43ac86ac9294

Can you try below

Regards,

[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

[Nawazish_Ahmad]

Hi @0bb4628e217fd43ac86ac9294

Try this:

Hope it will helps you