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.

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

DeepDarkThought wrote:

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.

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)

"DeepDarkThought" wrote in message
...
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.

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