transition remark

[lamchoria79]

[TABLE="width: 173"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Col 1[/TD]
[TD]Col 2[/TD]
[/TR]
[TR]
[TD]7/8[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5/8[/TD]
[TD]7/8x 5/8 [/TD]
[/TR]
[TR]
[TD]7/8[/TD]
[TD]5/8 x 7/8[/TD]
[/TR]
[TR]
[TD]7/8[/TD]
[TD]7/8 x 3/4[/TD]
[/TR]
[TR]
[TD]3/4[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3/4[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3/4[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3/4[/TD]
[TD]3/4 x 7/8[/TD]
[/TR]
[TR]
[TD]7/8[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

Hi everyone,
I need a helping hand. In my excel sheet, in col1 whenever value changes, i require a expression as shown in col 2. e.g. when in col 1 7/8 changes to 5/8 i require "7/8 x 5/8" in col 2. Also if value doesn't change then value in col2 should be blank.

 

[frank_AL]

Assuming there are headers in Row 1, place this formula in Cell B3
=IF(A3<>A2,CONCATENATE(A2," = ",A3," "),"")

 

[offthelip]

You requirements are inconsistent so are impossible to achieve or not completely specified:
on row 2 you have 7/8x 5/8 in column 2 , where row 1 changes to row 2 however on row 5 column 2 you have a blank, where row 4 changes to row 5 , ditto row 9

 

[JonXL]

You requirements are inconsistent so are impossible to achieve or not completely specified:
on row 2 you have 7/8x 5/8 in column 2 , where row 1 changes to row 2 however on row 5 column 2 you have a blank, where row 4 changes to row 5 , ditto row 9

I think the OP is looking for a way to store in B the current and previous value of A with the addition that when A has no previous value B is blank.

I don't think a formula will make this happen, but I also don't know the VBA to do it off hand.