Removing data to another tab!?
I want to be able highlight any data that is a duplicate (a certain
field:postcode) between different sheets, any suggestions? -- If you do what you always do you will get what you always get! |
Removing data to another tab!?
First decide which sheet is the one to be the "master" and which one you want
to find duplicates in. Let's say the postcodes you want to find duplicates IN are on Sheet2, and you want that sheet to be compared against postcodes in Sheet1. Let's put all the postcodes in column A for this example. On Sheet1, you'll have to name the range with the codes to check. Let's say A1:A1000 is your range, highlight it and enter Postcodes into the Name box (just to the left of the formula bar). Now, we'll use conditional formatting on the cells on Sheet2. Highlight the ENTIRE range you want to check for duplicates. Click FORMAT CONDITIONAL FORMATTING and enter this for the first condition: FormulaIs: =MATCH(A1,Postcodes,0) Then click FORMAT and set the highlighting you want, font or pattern (for background). Click OK. Now the postcodes on Sheet2 that are in the range from Sheet1 will change color to match your settings. Will this work for you? -- "Actually, I AM a rocket scientist." -- JB "PUVSTER" wrote: I want to be able highlight any data that is a duplicate (a certain field:postcode) between different sheets, any suggestions? -- If you do what you always do you will get what you always get! |
All times are GMT +1. The time now is 05:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com