transition remark

[lamchoria79]

Col 1	Col 2
7/8
5/8	7/8x 5/8
7/8	5/8 x 7/8
7/8	7/8 x 3/4
3/4
3/4
3/4
3/4	3/4 x 7/8
7/8

<colgroup><col><col></colgroup><tbody>
</tbody>

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.