I have two columns in Excel that I want to compare. The data in work sheet 1, column A has values that are tabbed. This data has the adjacent descriptions in the same work sheet column B, that I would like to keep connected.
There is another work sheet 2 that has the same values as mentioned above that have been wild carded by removing the duplicate tabs from a prior program. Lets call it column B of worksheet 2.
I would like to compare values in column A work sheet 1 with the values in column B worksheet 2 that are truncated and replaced with wild card value. I would like the values to be sorted and placed in a different column along with its description that is attached to the first set of data in worksheet 1.
So it looks like this.
Worksheet 1 Column A Column B
m00012345-1 description of A1
5678-01 description of A2
5678-02 description of A3
Having a hard time picturing this data, pls send a link to download for review and I can probably work on this.
Provide a sheet3 with how the data is suppose to be after the comparison so I know what result you are looking for.