Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Multiple Columns -
I need to combine two lists of parts numbers - both list are not identical
they share 80% of the same part numbers but I need the data to line up with the master list. I need the numbers to line up across from each other Thanks in advance Master # 2nd list 1 2 2 4 3 6 4 8 5 10 6 7 8 9 10 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Multiple Columns -
This might suffice
In C2: =IF(ISNUMBER(MATCH(A2,B:B,0)),A2,"") Copy down If desired, kill the formulas with an "in-place" copy n paste special as values, then delete col B -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "L Brandon" wrote: I need to combine two lists of parts numbers - both list are not identical they share 80% of the same part numbers but I need the data to line up with the master list. I need the numbers to line up across from each other Thanks in advance Master # 2nd list 1 2 2 4 3 6 4 8 5 10 6 7 8 9 10 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Multiple Columns -
Hi LB,
Try this. If your Master list starts in A1, and your 2nd list starts in B1: Place this formula in C1 and fill down to the last row of data in Column A. =IF(ISERROR(MATCH(A1,$B$1:$B$5,0)),"",INDEX($B$1:$ B$5,MATCH(A1,$B$1:$B$5,0))) Regards - Dave. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting multiple columns | Excel Worksheet Functions | |||
Sorting Multiple Columns | Excel Discussion (Misc queries) | |||
Sorting multiple columns | New Users to Excel | |||
Sorting in multiple columns | Excel Discussion (Misc queries) | |||
Sorting multiple columns together | Excel Discussion (Misc queries) |