Forum Discussion
Find Numbers based on a List and delete them
I have a list that has 9 rows of phone numbers, I have another list of numbers that I can not use. I need to use the second list of numbers find those numbers in the first list and just delete the nu...
Do I understand correctly you have 9 columns x 2000 rows in first list?
If second list is in column A, you may add next helper column with formula as
=COUNTIF(FirstListRange,A1)=0drag it down till end of the second list, filter this column FALSE and delete all filtered records.