Check for duplicate data

[WBTKbeezy]

I have 12 columns each with various amounts of data in them. I am trying to
see if there are any duplicates on the sheet at all so column B might have
data that is also in column E, and column A might have data that is also in
column L. I need a way to see which items are duplicates and highlight them
possibly.
I tried the

=if(countif(A:A,B1)>0,"Dup","")

function listed in this forum, but it is not very efficient for the amount
of data I have, can anyone help?

[Anne Troy]

Try this:
http://www.cpearson.com/excel/duplic...tingDuplicates
Maybe that will work better for you.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"WBTKbeezy" <[email protected]> wrote in message
news:[email protected]...
>I have 12 columns each with various amounts of data in them. I am trying
>to
> see if there are any duplicates on the sheet at all so column B might have
> data that is also in column E, and column A might have data that is also
> in
> column L. I need a way to see which items are duplicates and highlight
> them
> possibly.
> I tried the
>
> =if(countif(A:A,B1)>0,"Dup","")
>
> function listed in this forum, but it is not very efficient for the amount
> of data I have, can anyone help?