View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jon Davis Jon Davis is offline
external usenet poster
 
Posts: 1
Default Compare two columns by aligning same-values and spacing out differences

How space out mismatches of two similar columns while keeping like cells
aligned? For example, how do I convert a worksheet containing (in columns A
and B):

A A
B B
C D
D E
F G
....

... to ..

A A
B B
C
D D
E
F
G