Need help on Duplication data - Please help me!

  • Thread starter Thread starter Laurenz
  • Start date Start date
L

Laurenz

Hi everyone,

I'm hoping that anyone out there can help me with my
problem with duplication data on the excel that I'm
currently working on. I'm reviewing large number of data
entry on excel at the moment and my main task is to
identify any duplication data entry. At the moment the
macro that I'm using is not giving my 100% result. What
I'm seeking is a macro that can be run and highlighten any
duplicates data in a colum without delecting the data. I
will really appreciate it if anyone can help me with this
as it will be great help. I thank you all in advance.
 
Laurenz,

You can insert a helper column, and identify duplicates with a formula.
I'll say you're keying on column A, and the first record is in row 2.
Insert a column (now B). The first formula is in B2:

=IF(A3-A2, "Dup","")

Copy this down with the fill handle.

Earl Kiosterud
Mvpearl omitthisword at verizon period net.
 
Laurenz,

Also, you must first sort the table on the column of interest for this to
work.

Earl Kiosterud
Mvpearl omitthisword at verizon period net.
--------------------------------------------
 
If you want all duplicate values to be highlighted, select the column and
conditionally format with this formula:

=COUNTIF(A:A,A1) >1


If you want all but the first occurance to be highlighted, use this formula
instead:

=COUNTIF($A$1:$A1,A1) >1

HTH

-Dave
 
Back
Top