Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

All cells in a row match in multiple columns

I need a formula that will produce the word "Yes" or "No" in the Match column if all the cells in a row of 4 columns match

Example

Column 1     Column2     Column3     Column4     Match
Apple            Apple          Orange         Apple          NO
Banana         Banana      Banana         Banana       YES
0
ablove3
Asked:
ablove3
1 Solution
 
Santosh GuptaCommented:
Try
=IF(AND(A1=B1,B1=C1,C1=D1),"yes","no")
0
 
Saqib Husain, SyedEngineerCommented:
Try

=IF(SUMPRODUCT(--(A2:C2=B2:D2))=3,"Yes","No")
0
 
NBVCCommented:
Try:

=IF(COUNTIF(A2:D2,A2)=4,"YES","NO")
0
 
ablove3Author Commented:
I selected this answer, because it gave me the flexibilty to compare columns that were not all next to each other.

Thank you all for your input.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now