samunder
11-08-2008, 04:26 PM
Hi,
I am working on an excel solution where I need to open an excel file with 20 columns and 1000 rows, remove unwanted rows based on multiple criteria. One of the columns (the first one) is "CodeNo" which can have values between 1 and 100. I need to retain the rows with values 10, 20, 40 and 70 and remove the rest of them. I tried to apply the advanced filter (with <>10, <>20, <>40, <>70) but it seems the filter is not being applied cumulatively and I end up with all the rows as they are.
Please help me solve this. Is there a way to filter cumulatively? :think:
I am working on an excel solution where I need to open an excel file with 20 columns and 1000 rows, remove unwanted rows based on multiple criteria. One of the columns (the first one) is "CodeNo" which can have values between 1 and 100. I need to retain the rows with values 10, 20, 40 and 70 and remove the rest of them. I tried to apply the advanced filter (with <>10, <>20, <>40, <>70) but it seems the filter is not being applied cumulatively and I end up with all the rows as they are.
Please help me solve this. Is there a way to filter cumulatively? :think: