prochasska
New Member
- Joined
- Jan 16, 2018
- Messages
- 9
Hi,
I have a big table where I need a formula to do the following:
Example:
<colgroup><col></colgroup><tbody>
</tbody>
Example:
<colgroup><col></colgroup><tbody>
</tbody>
I have tried to use if and countif, but the formula returns "yes" only for the first cell. I need the formula to return yes for all six cells.
I hope someone can help with this formula.
I have a big table where I need a formula to do the following:
- if six cells in a column contain the same value, the formula should return "yes"
Example:
column N |
Los Angeles |
Los Angeles |
Los Angeles |
Los Angeles |
Los Angeles |
Los Angeles |
<colgroup><col></colgroup><tbody>
</tbody>
- if six cells in a column contain different values, the formula should return "no"
Example:
column N |
Los Angeles |
Los Angeles |
Los Angeles |
Barcelona |
Barcelona |
Rome |
<colgroup><col></colgroup><tbody>
</tbody>
I have tried to use if and countif, but the formula returns "yes" only for the first cell. I need the formula to return yes for all six cells.
I hope someone can help with this formula.