Thread: How can I check for dupes in more than one column in excel?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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?
Reply With QuoteReply With Quote