ExcelBanter - comapre two list of data & arranging in a same manner

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sachin" wrote:
compare two list of data & arranging in a same manner