comapre two list of data & arranging in a same manner

M

Max

One venture ..

Assuming the 2 data lists are in cols A and B, from row1 down

To arrange list in col A with that in col B
Put in say, C1:
=IF(ISNA(MATCH(B1,A:A,0)),"",INDEX(A:A,MATCH(B1,A:A,0)))
Copy C1 down to last row of data in col B

And the other way around ..
To arrange list in col B with that in col A
Put in say, D1:
=IF(ISNA(MATCH(A1,B:B,0)),"",INDEX(B:B,MATCH(A1,B:B,0)))
Copy D1 down to last row of data in col A

Items in col A not found in col B if any, will not appear.
Similarly for the converse situation

Note: You should always elaborate on the subject line in your post's message
area. Do not leave the message area blank.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index/Match Lookup with a merged col 2
Find string from column A in Range("B2:F7") list the header of that column/s 5
Non-Array Play to Eliminate Blank Cells 5
Function to mapping data 0
Manipulating Table data 1
Transpose 4 Columns data to Rows for Employee Time In and Time Out Schedule 0
Compare & align 2 cols of Employee Names in sorted alpha order withVBA 4
Deconstructing a table 1

Top