Thread: comparing 3 columns
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default comparing 3 columns
=AND(A2=B2,B2=C2)
returns True if A2=B2=C2
Fill it down as necessary!

Regards,
Stefi

€˛Ukiuki€¯ ezt Ć*rta:

How do I compare 3 columns? Need to know the data in all 3 columns are the
same.

Reply With QuoteReply With Quote