1

I am working on comparing markup values between three different databases. I have each database in a seperate colomn. What is the formula to see if all 6 markup values are the same. To get a Yes if they are and a no if they are not? Any help would be great!

Improve this question

1 Answer 1

Reset to default
3

Exact will return True if the cells are the same. 

=EXACT(A1,B1)

enter image description here

or for multiple values: 1=true (same)

=SUMPRODUCT((A1=B1)*(B1=C1)*(C1=D1)*(D1=E1)*(E1=F1))

enter image description here

Improve this answer
2
  • Yes, but it will only allow me to do two columns I have 6.
    – Rebecca
    May 18, 2012 at 19:36
  • Try edited version
    – adayzdone
    May 18, 2012 at 19:54

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .