combining data

[jamie.boswell]

Hi,

I am trying to write macro to compare rows of data, for example

row1 0 1 0 0 1 1 0 0
row2 0 0 1 0 0 0 0 1

combined would be

row1 0 1 1 0 1 1 0 1

Once combined the second row will be deleted. There is never an
instance when row1 and row2 will each have a 1 in the same position.

Is there a simple method to achieve this? Does anyone have any
examples?

Thanks for your help, James.

 

[Dave Peterson]

Why not just add the two rows, convert the formulas to values and delete both
original rows?