Hi. I'm trying to concat Cell A, B, and C. However, I don't want to concat the row if column A has "N".
For example, below I would like to skip 4and 5 because column A has "N".
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">Hi. I'm trying to concat Cell A, B, and C. However, I don't want to concat the row if column A has "N".
For example, Below I would like to skip row 4 and 5 because column A has "N". (Highlighted in yellow)
Thanks,
Jenny</body>
<colgroup>
</colgroup><tbody>
</tbody>
For example, below I would like to skip 4and 5 because column A has "N".
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">Hi. I'm trying to concat Cell A, B, and C. However, I don't want to concat the row if column A has "N".
For example, Below I would like to skip row 4 and 5 because column A has "N". (Highlighted in yellow)
Thanks,
Jenny</body>
A | B | C | Concate |
y | Dodge | c100 | yDodgec100 |
y | Cap | c101 | yCapc101 |
n | Circus | c102 | nCircusc102 |
n | Warren | c103 | nWarrenc103 |
y | Tooker | c104 | yTookerc104 |
y | Dodge | c100 | yDodgec100 |
<colgroup>
</colgroup><tbody>
</tbody>