Compare cells in a row

[puiuluipui]

Hi, i need to compare a range in the same row (A1:G1) to see if all entries
are the same. If all cells contains the same value, then to return true. If
Entries are not the same, then the formula to return false.
Can this be done?
Thanks!

 

[Don Guillett]

=IF(COUNTIF(A1:E1,A1)=5,TRUE,"")

 

[puiuluipui]

It's working, but with exact range. Can a formula look in A1:E1 and display
true or false even though only A1,B1 and c1 are filled?

A1 = yes
B1 = yes
C1 = no

Range A1:E1
Formula result =False (in this situation) or true

Can this be done?
Thanks!

 

[Don Guillett]

=IF(COUNTIF(A19:G19,"yes")=COUNTA(A19:G19),TRUE,"")

 

[puiuluipui]

Works great!
Thanks!

=IF(COUNTIF(A19:G19,"yes")=COUNTA(A19:G19),TRUE,"")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)