asked on Conditional Format to match numbers
Hello,
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.
Thank you,
Walter Humko
Bid-Number-Weekly--3-Aug-15.xlsx
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.
Thank you,
Walter Humko
Bid-Number-Weekly--3-Aug-15.xlsx
Microsoft ExcelVBA
Last Comment
WalterAPO
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
If deleting from the Weekly list put this formula in B2 and fill down:
Then you can filter for the False values in column B and delete those rows.
=IsError(Match(A2,Perm!B:B,0))
Then you can filter for the False values in column B and delete those rows.
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
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
ASKER
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.
Again, thank you.
Walter
Again, thank you.
Walter
From which worksheet are you deleting rows?