Thread: comparing 3 columns
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ukiuki Ukiuki is offline
external usenet poster
  
Posts: 2
Default comparing 3 columns
Thanks! :)

"Stefi" wrote:

=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