Fill in blank cells based off criteria

[mando415]

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:

• 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.



[TABLE="width: 125"]
<tbody>[TR]
[TD][TABLE="width: 56"]
<colgroup><col width="56" style="width:42pt"> </colgroup><tbody>[TR]
[TD="width: 56"]Trans[/TD]
[/TR]
[TR]
[TD="align: right"]53514[/TD]
[/TR]
[TR]
[TD="align: right"]53514[/TD]
[/TR]
[TR]
[TD="align: right"]53535[/TD]
[/TR]
[TR]
[TD="align: right"]53535[/TD]
[/TR]
[TR]
[TD="align: right"]86453[/TD]
[/TR]
[TR]
[TD="align: right"]86453[/TD]
[/TR]
[TR]
[TD="align: right"]86453[/TD]
[/TR]
[TR]
[TD="align: right"]86453[/TD]
[/TR]
[TR]
[TD="align: right"]86454[/TD]
[/TR]
[TR]
[TD="align: right"]86454[/TD]
[/TR]
[TR]
[TD="align: right"]86486[/TD]
[/TR]
[TR]
[TD="align: right"]86486[/TD]
[/TR]
[TR]
[TD="align: right"]53556[/TD]
[/TR]
[TR]
[TD="align: right"]67060[/TD]
[/TR]
[TR]
[TD="align: right"]67060[/TD]
[/TR]
[TR]
[TD="align: right"]67060[/TD]
[/TR]
[TR]
[TD="align: right"]69346[/TD]
[/TR]
[TR]
[TD="align: right"]90011[/TD]
[/TR]
[TR]
[TD="align: right"]53601[/TD]
[/TR]
[TR]
[TD="align: right"]58768[/TD]
[/TR]
[TR]
[TD="align: right"]58768[/TD]
[/TR]
[TR]
[TD="align: right"]58768[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 132"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Reason[/TD]
[/TR]
[TR]
[TD]Exchange[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Unwanted Gift[/TD]
[/TR]
[TR]
[TD]Unwanted Gift[/TD]
[/TR]
[TR]
[TD]Unsuitable[/TD]
[/TR]
[TR]
[TD]Unsuitable[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Unsuitable[/TD]
[/TR]
[TR]
[TD]Unsuitable[/TD]
[/TR]
[TR]
[TD]Exchange[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]E-Commerce Order Return[/TD]
[/TR]
[TR]
[TD]Exchange[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Unsuitable[/TD]
[/TR]
[TR]
[TD]Unsuitable[/TD]
[/TR]
[TR]
[TD]Unwanted Gift[/TD]
[/TR]
[TR]
[TD]Wrong Size[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[FDibbins]

I would do this with a helper ciolumn (C), using this, copied down...
=IF(B2="",D1,IF(A2=A1,D1,B2))

You can then either hide B, or copy/paste values C over B and then delete C

 

[mando415]

Ford - Thank you. My mind started weekend mode a bit early today!

Case closed...