How can I check for dupes in more than one column in excel?
 

I know how to use conditional formatting to search for dupes in one column-
but how do I cross check more than one column of data for dupes?

How can I check for dupes in more than one column in excel?
 

http://www.j-walk.com/ss/excel/usertips/tip073.htm

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"latwood" escreveu:

I know how to use conditional formatting to search for dupes in one column-
but how do I cross check more than one column of data for dupes?

How can I check for dupes in more than one column in excel?
 

=COUNTIF(A1:F100,"criteria")
Adjust your range, and the criteria

"latwood" wrote:

I know how to use conditional formatting to search for dupes in one column-
but how do I cross check more than one column of data for dupes?