I have 2 columns that have various numerical values in them. There are a lot of matching values in both the columns, however there are some unique values that appear in one column but not the other. I'd like to match up the correct values, and where the unique values appear, I'd like the opposite column to have a blank space.
For example:
Column A:
1
2
4
5
Column B:
2
3
4
5
What I'd like to see:
1
2 2
3
4 4
5 5
thank you for any help
Normally I don't jump on posts that do not have sample workbooks. However, this one was simple enough to set up.
This solution depends upon "you sort of have to know" what the answer looks like. That is, the results will be consecutive numbers from 1 to 5 as outlined in Column D. Then I used VLOOKUP to see if the number appears in column A or column B in columns E & F. Column G is just the concatenation of E & F and column H is the same formula as G with the helper formulas substituted in so it is all in terms of A & B.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks