How to determine duplicate records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello there!

Anybody could help me?
I want to know if there is a way I could determine a
duplicate entry about 10000 records becuase i do it
manually:
for example Sheet 1 -employee number, is there a way in
conditional formating I will know or fill the data with
duplicate records.
thanks
 
Assuming your data is in column A, then --

1] Select cell A1
2] goto Format | Conditional Formatting
3] Select Formula Is
4] in the formula box, enter: =IF(COUNTIF(A$1:A1,A1)>1
5] Select the desired formatting options
6] Select all other cells to which you want to apply this condition
7] goto Copy | Paste Special | Formats

Note: This will highlight the 2nd, and successive, instances but *not
the 1st
 
singkit said:
*Hello,

I'd like to know if there is easier way to determine the
records with duplicate data.
for example:
Sheet 1 contains about 10000 records from here there are
duplicate employee number. How will I know which row has
duplicate.
Thanks. *
Click to expand...

How do you want the duplicates flagged? Do you want to include the 1s
instance as well, or only instances after the initial entry
 
Back
Top