I have a table of data values to import into a database. One of the columns is called NAME.
I have another table with only one colum: Known values of NAME.
How do I use the second table to delete all rows with a known NAME from the first table…
Hello
- in the second sheet create a formula to concatenate all »known names« eg:
="^" & TEXTJOIN("$|^"; 1 ; A:A) & "$"
copy the Formula-result with ctrl+c
- in the first sheet, select the Column in question, and open the Search&replace-dialog
- paste with ctrl+v the formula-result into the search-field, check [x]selection only and [x]regular Expression … click on find all
- close the S&R-Dialog
- right-click somewhere on the Row-headers, and choose delete Rows