Find and Delete
The are 3400 numbers in Col A this is a banned section.
If an identical number appears in Col B containing 23,000 numbers it needs to be deleted from Col B Only. thanks Karen |
Find and Delete
Karen,
Try this in C1 =IF(COUNTIF($A$1:$A$3400,B1)0,B1,"") Fill down to the length of column B data range and it will give a list of duplicated number in Column B. Sort columns B & C together by column C descending and all the duplicates in Column B should be at the bottom for deletion. Mike "Karen" wrote: The are 3400 numbers in Col A this is a banned section. If an identical number appears in Col B containing 23,000 numbers it needs to be deleted from Col B Only. thanks Karen |
Find and Delete
hi karen,
i will try the same way with Mike with some more effort to delete the cells containing the unwanted numbers and arrange column B as if nothing happened. regards, driller -- ***** birds of the same feather flock together.. "Karen" wrote: The are 3400 numbers in Col A this is a banned section. If an identical number appears in Col B containing 23,000 numbers it needs to be deleted from Col B Only. thanks Karen |
All times are GMT +1. The time now is 11:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com