Finding duplicated entries in a llist

D

DeepDarkThought

I am using Excel 2002 (10.5815.4219) SP-2

I have a spreadsheet of about 2,400 rows about invoices in a numbered
sequence. The data were collected from a variety of sources so there is a
risk of duplication.

Is there an elegant function/macro I can use to highlight duplicated items
in a column without reading it by eye.
 
B

Bob Phillips

In an adjacent column

=IF(COUNTIF(A:A,A1)>1,"Duplicate","")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Y

yogendra joshi

Really Easy... No need for programs

You can use Conditional Formatting:

1. Select the entire range in which you have the invoices...
If it is expected that there can be more entries, best to select
the entire column, in this case say column A
2. Format -> Conditional Formatting
Formula is "=COUNTIF(A:A,A1)>1"
(Considering that A1 cell is active)
3. Select the formatting you want.
4. Press Ok.


All the entries in your data which are repeated will be highlited with
your formatting.

Thanks,

Yogendra
 
R

Rob

Use codnitional formatting
Formula is: =countif(A:A,A1)>


----- DeepDarkThought wrote: ----

I am using Excel 2002 (10.5815.4219) SP-

I have a spreadsheet of about 2,400 rows about invoices in a numbere
sequence. The data were collected from a variety of sources so there is
risk of duplication

Is there an elegant function/macro I can use to highlight duplicated item
in a column without reading it by eye
 
Top