Happy Friday everyone,
I have 2 columns of data (A-Trans and B-Reason) - each trans in col A should should have a reason in col B.
The logic I am trying to apply is:
I am looking for a solution for this problem. I preferably am looking for a formula in col C that I could then copy back over Col B as values.
Apologies if i did not explain this better.
<tbody>
</tbody>
I have 2 columns of data (A-Trans and B-Reason) - each trans in col A should should have a reason in col B.
The logic I am trying to apply is:
- if A3<>A2 do nothing.
- if A3=A2 and B3 is blank, B3=B2
I am looking for a solution for this problem. I preferably am looking for a formula in col C that I could then copy back over Col B as values.
Apologies if i did not explain this better.
<colgroup><col width="56" style="width:42pt"> </colgroup><tbody> </tbody> |
<colgroup><col></colgroup><tbody> </tbody> |
<tbody>
</tbody>