There are 2 sheets in the attached spreadsheet. The 1st sheet, Weekly, has about 3,000 lines and I download this weekly. The 2nd sheet, Perm, are my numbers. I tried to use Conditional Formatting find duplicates, but I can’t get it to work. I need the Conditional formatting to find my number out of the almost 3,000 and then I will delete the other numbers.
Then you can filter for the False values in column B and delete those rows.
Subodh Tiwari (Neeraj)
Since this is a regular process for you, I would suggest to go for a VBA solution, you will need to click a button after placing weekly data on Weekly Sheet and your duplicated numbers will be deleted instantly.
Please find the workbook and click on the button Delete Duplicates on Weekly Sheet to delete those numbers from Weekly Sheet which are present in both the sheets Weekly and Perm.
After downloading the workbook, don't forget to enable macros or contents while prompted when opening the file first time. Bid-Number-Weekly--3-Aug-15.xlsm
Thank you this is a very easy solution. I can share this with my coworkers and it will significatnly reduce the time it takes to update my spreadsheet. This is hard to pick the best solution, because the others are great too.
From which worksheet are you deleting rows?