software

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)gt;0,quot;Dupquot;,quot;quot;)

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

Try this:
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

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