| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CAn IF compare two cells? | Excel Worksheet Functions | |||
| Compare 400 cells to one | Excel Worksheet Functions | |||
| Compare 2 cells for a value | Excel Discussion (Misc queries) | |||
| How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
| Compare two cells from reference cells | Excel Worksheet Functions | |||
Linear Mode
