Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Duplicate Information
Hi,
I was wondering if it were possible to have a macro that searches each column, Ranges A1:A5, for duplicate numbers/information/values before I close the spreadsheet and then have it alert me when it finds any? If it is, does anyone know where I can get a macro like that? Heck, I wouldn't mind if I had to run it manually either, just something that can find dups without me having to eyeball hundreds of lines through five columns. Thanks Very Much In Advance, Rob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Duplicate Information
Without a Macro - You could use Conditional Formatting
Sample below (say yoor data range is A1:D10) 1) With A1 the activecell - Highlight A1:D10 2) Format, ConditionalFormatting... 3) Select FormulaIs (from Drop-down) an in box paste the below formula. 4) Choose a Color 5) OK Out... =COUNTIF($A$1:$D$10,A1)1 'Note first argument if Absolute, 2nd is not Write back if problems; Jim =COUNTIF($A$1:$D$10,A1)1 "Rob" wrote: Hi, I was wondering if it were possible to have a macro that searches each column, Ranges A1:A5, for duplicate numbers/information/values before I close the spreadsheet and then have it alert me when it finds any? If it is, does anyone know where I can get a macro like that? Heck, I wouldn't mind if I had to run it manually either, just something that can find dups without me having to eyeball hundreds of lines through five columns. Thanks Very Much In Advance, Rob |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Duplicate Information
Hi,
You can use "Advanced Filter", by selecting the Unquie Records only check box in the Advanced Filter dialog box. If this method is not appropriate for your solution, then a macro could be considered as a desired choice. Challa Prabhu "Rob" wrote: Hi, I was wondering if it were possible to have a macro that searches each column, Ranges A1:A5, for duplicate numbers/information/values before I close the spreadsheet and then have it alert me when it finds any? If it is, does anyone know where I can get a macro like that? Heck, I wouldn't mind if I had to run it manually either, just something that can find dups without me having to eyeball hundreds of lines through five columns. Thanks Very Much In Advance, Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filtering out rows with duplicate information | Excel Discussion (Misc queries) | |||
process of elimination of duplicate information | Excel Discussion (Misc queries) | |||
Duplicate information | Excel Worksheet Functions | |||
merging information from partial duplicate rows | Excel Discussion (Misc queries) | |||
Duplicate information | Excel Discussion (Misc queries) |