I’m trying to filter a data in excel file without moving the data into DataTable. I understand we can use Filter Table activity under Excel Application Integration. However currently I tried to filter a column where the data are generated from VLookup formula and I would like to tick all filter value except #N/A.
Thank you very much, it’s work for filtering data using DataTable. I Just wondering whether we can filter it without store the data in DataTable? So just filter in Excel using Filter Table Activity.
Thank you very much!
Actually i already finish with the VLookup part. Next I would like to filter the result from the Vlookup only to show value that are not #N/A. If possible without using datatable. i.e. Just filter directly in Excel using Filter Table Activity.
Hey, I see the file attached for filter #N/A. Would you able to guide me on remove filtered rows. I have entire excel with formula in each cell. so, want to remove #N/A and more rows from filtering columns.