melbwarrior
New Member
- Joined
- Apr 19, 2018
- Messages
- 16
Hello all
Looking for some help on what will probably be a simple excel formula:
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>
If A1 is the same as A2 etc then return true, but when the cell content changes like for example when a4 goes from a to c my IF formula breaks down or doesn't return the result required
I would want this repeated for columns B and C returning the value in D.
So if the contents in A match and B match and C match = then return true.
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
The above for example is true as it displays matching criteria in the 3 columns
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
This would be false
Hope that makes sense
Thanks in advance
Looking for some help on what will probably be a simple excel formula:
A | B | C | |
a | b | 1 | |
a | b | 1 | |
a | b | 1 | |
c | s | 2 | |
d | s | 3 | |
e | s | 2 | |
f | s | 2 | |
f | s | 2 | |
f | s | 2 | |
f | s | 2 |
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>
If A1 is the same as A2 etc then return true, but when the cell content changes like for example when a4 goes from a to c my IF formula breaks down or doesn't return the result required
I would want this repeated for columns B and C returning the value in D.
So if the contents in A match and B match and C match = then return true.
a | b | 1 |
a | b | 1 |
a | b | 1 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
The above for example is true as it displays matching criteria in the 3 columns
c | s | 2 |
d | s | 3 |
e | s | 2 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
This would be false
Hope that makes sense
Thanks in advance