Forum Discussion

IvanB2's avatar
IvanB2
Copper Contributor
Jan 30, 2020

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 number in the cell. Is this possible with out doing it manualy. I have Excel 365 and Excel 2010. The first list is about 2000 rows about 10000 phone numbers and the second list has about 4000 phone numbers in one column.

 

excel

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 30, 2020

    IvanB2 

    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)=0

    drag it down till end of the second list, filter this column FALSE and delete all filtered records.

  • Charla74's avatar
    Charla74
    Iron Contributor
    Jan 30, 2020
    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.

Resources