Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |