Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving data from one worksheet to another whilst removing the data | Excel Discussion (Misc queries) | |||
Removing Data Tables formed from importing data from Access | Excel Discussion (Misc queries) | |||
Removing Data | Excel Worksheet Functions | |||
removing tabs from data | Excel Discussion (Misc queries) | |||
Removing only certain data in a cell | Excel Discussion (Misc queries) |