Re: Check for duplicate data

Try this:
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates
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" <WBTKbeezy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3B42BAC9-58B6-4FA4-90A8-D01DD14262D7@xxxxxxxxxxxxxxxx
I have 12 columns each with various amounts of data in them. I am trying
to
see if there are any duplicates on the *** 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?


.