Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
comapre two list of data & arranging in a same manner
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) |