Hi there,
In column A I have a list of 50 phone numbers. In column B I have a list of 10,000 phone numbers. I need a forumla to delete the 50 from the 10,000.
Thanks!
Hi there,
In column A I have a list of 50 phone numbers. In column B I have a list of 10,000 phone numbers. I need a forumla to delete the 50 from the 10,000.
Thanks!
Formulas don't delete. You could use a countif function to flag if the Col A data in Col B then filter on the flag
See link for more
http://www.cpearson.com/excel/ListFunctions.aspx
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Sorry, I am not very good at this stuff. I uploaded an example.
Thanks
See example
Filter on 1's in Col C and delete
VBA Noob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks