Compare cells in a row

  • Thread starter Thread starter puiuluipui
  • Start date Start date
P

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!
 
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!
 
Works great!
Thanks!

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Click to expand...
 
Back
Top