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...
You could use a VLOOKUP formula alongside the larger list, checking to see if the number is in the smaller list of ‘do not use’ numbers. You could then add a filter for matches and delete data as required.