Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Highlighting duplicates across many sheets
I have seen many posts on this topic, but so far nothing has worked. I have about 13 sheets of data, for which I am only concerned with column D. I want to highlight any duplicate entries in column D from sheet 4 through 13 (I have renamed them)--only highlight, as I want to review them before deleting. A clear guide would be much appreciated.
Thanks a lot. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlighting duplicates across many sheets
jpeevy laid this down on his screen :
I have seen many posts on this topic, but so far nothing has worked. I have about 13 sheets of data, for which I am only concerned with column D. I want to highlight any duplicate entries in column D from sheet 4 through 13 (I have renamed them)--only highlight, as I want to review them before deleting. A clear guide would be much appreciated. Thanks a lot. You could use ConditionalFormatting (CF)... Select column D (entire column) In the CF dialog: Select Formula is from the dropdown Enter: =countif($D:$D,$D1)1 Click the Format... button and choose the pattern you want Repeat this for each sheet... -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlighting duplicates across many sheets
Is jpeevy in D3 of Sheet9 considered a duplicate of jpeevy in D26 of
Sheet4? Or just a duplicate on its own sheet? Gord On Thu, 19 Jan 2012 20:07:54 +0000, jpeevy wrote: I have seen many posts on this topic, but so far nothing has worked. I have about 13 sheets of data, for which I am only concerned with column D. I want to highlight any duplicate entries in column D from sheet 4 through 13 (I have renamed them)--only highlight, as I want to review them before deleting. A clear guide would be much appreciated. Thanks a lot. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlighting duplicates across many sheets
Gord Dibben laid this down on his screen :
Is jpeevy in D3 of Sheet9 considered a duplicate of jpeevy in D26 of Sheet4? Or just a duplicate on its own sheet? Gord On Thu, 19 Jan 2012 20:07:54 +0000, jpeevy wrote: I have seen many posts on this topic, but so far nothing has worked. I have about 13 sheets of data, for which I am only concerned with column D. I want to highlight any duplicate entries in column D from sheet 4 through 13 (I have renamed them)--only highlight, as I want to review them before deleting. A clear guide would be much appreciated. Thanks a lot. Good point! -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
highlighting duplicates...except it doesn't | Excel Discussion (Misc queries) | |||
Need Help with Highlighting duplicates across several sheets | Excel Worksheet Functions | |||
highlighting duplicates | Excel Worksheet Functions | |||
Help with Highlighting all duplicates in a row | Excel Discussion (Misc queries) | |||
Highlighting Duplicates | New Users to Excel |