How to lineup 2 columns of data?
Posted by Brian Bankey on February 24, 2000 8:10 PM
I have 2 columns of sorted data (ex. customer numbers).
Not all of the numbers in the two columns
match each other. Some are unique in column A.
Some are unique in column B.
I would like to line up the cells in the 2 columns
on the same row where the numbers match.
Where there is no match I need to insert
a blank cell in the appropriate column (A or B).
The inserted cell corrects the alignment between
the 2 columns.
How would you do this?