i have a table and their are 3 columns in these 3 columns some cells contain codes
i want to check if at least on of the cell contain the code delete the whole row
romove the row if it contain a code from one of the coloumn
- tharusha
- Thread is marked as Resolved.
-
-
What code do you mean?
-
Sorry i forgot to mention Code, Code2 ,code3 are column names at least one of the
above column contain a code (number) i want to delete the whole row
out put should be the highlight row -
I still don't understand, do you mean NH, in which case all rows would be deleted
-
-
So you mean if the row contains the error #N/A?
-
There aren't any rows that don't contain NH.
Please attach a better example, with the errors in
-
-
Do you want to keep rows if there are 3 errors?
-
-
If the cells contain errors caused by VLOOKUP then this should work
-
Pleased to help
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!