mperrah
07-18-2012, 09:33 AM
I am comparing data between two columns (other cells are adjoined).
There are other columns of data included that need to line up across the rows.
There are many items with multiple entries in column "E" and "F" that match.
When they don't match I want to add empty cells next to the unmatched item left or right.
So in the end i have every row having a single item matched across
or a single item and blank cells next to it (duplicates are expected).
i.e. If "E" has no match in "F" add cells to right,
if "F" has no match in "E" add cells to left.
Cells A-E are the first item, cells F-G are second item.
E and F are the cells to compare.
If F matches G do nothing.
If F doesn't match G add cells to F, G, H and shift down
If F is not in G, add cells to A, B, C, D, E and shift down
The data is sorted alpha/numerically top to bottom
I'm trying to get a sequential list of all items
based on the values of "E" and "F"
I have attached a file with a before and after sheet of sample data.
sorry to be so verbose, but I have found the more detailed at the beginning helps eliminate wasted efforts
- thanks in advance.
mark
There are other columns of data included that need to line up across the rows.
There are many items with multiple entries in column "E" and "F" that match.
When they don't match I want to add empty cells next to the unmatched item left or right.
So in the end i have every row having a single item matched across
or a single item and blank cells next to it (duplicates are expected).
i.e. If "E" has no match in "F" add cells to right,
if "F" has no match in "E" add cells to left.
Cells A-E are the first item, cells F-G are second item.
E and F are the cells to compare.
If F matches G do nothing.
If F doesn't match G add cells to F, G, H and shift down
If F is not in G, add cells to A, B, C, D, E and shift down
The data is sorted alpha/numerically top to bottom
I'm trying to get a sequential list of all items
based on the values of "E" and "F"
I have attached a file with a before and after sheet of sample data.
sorry to be so verbose, but I have found the more detailed at the beginning helps eliminate wasted efforts
- thanks in advance.
mark