Compare cells in a row
 

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!

Compare cells in a row
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"puiuluipui" wrote in message
...
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!

Compare cells in a row
 

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" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"puiuluipui" wrote in message
...
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!

Compare cells in a row
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"puiuluipui" wrote in message
...
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" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"puiuluipui" wrote in message
...
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!

Compare cells in a row
 

Works great!
Thanks!

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"puiuluipui" wrote in message
...
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" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"puiuluipui" wrote in message
...
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!