Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting data
I would like to be able to pull out certain numbers (B# in below table) from
a list A# in below table and copy the associated row values. In the example below, starting with the left three columns how do I go to the right three columns given the B# value column. A# B# 1 23 5242 1 23 5242 2 34 53 3 245 25 3 245 25 4 245 25 4 245 25 6 4 5245 5 45 24 7 2 22 6 4 5245 8 4525 4 7 2 22 10 245 3 8 4525 4 11 45 45 9 2 4 14 3 24 10 245 3 11 45 45 12 3 4 13 445 3 14 3 24 15 245 5 Thanks! Ian |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting data
Assume your source data in cols A to C, from row2 down
With your B#s listed in E2 down, Put in F2: =INDEX(B:B,MATCH($E2,$A:$A,0)) Copy F2 to G2, fill down as required -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "I. Miller" wrote: I would like to be able to pull out certain numbers (B# in below table) from a list A# in below table and copy the associated row values. In the example below, starting with the left three columns how do I go to the right three columns given the B# value column. A# B# 1 23 5242 1 23 5242 2 34 53 3 245 25 3 245 25 4 245 25 4 245 25 6 4 5245 5 45 24 7 2 22 6 4 5245 8 4525 4 7 2 22 10 245 3 8 4525 4 11 45 45 9 2 4 14 3 24 10 245 3 11 45 45 12 3 4 13 445 3 14 3 24 15 245 5 Thanks! Ian |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting data
Max, thank you again! You also helped me with the Pivot Table advice yesterday.
Cheers! "Max" wrote: Assume your source data in cols A to C, from row2 down With your B#s listed in E2 down, Put in F2: =INDEX(B:B,MATCH($E2,$A:$A,0)) Copy F2 to G2, fill down as required -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "I. Miller" wrote: I would like to be able to pull out certain numbers (B# in below table) from a list A# in below table and copy the associated row values. In the example below, starting with the left three columns how do I go to the right three columns given the B# value column. A# B# 1 23 5242 1 23 5242 2 34 53 3 245 25 3 245 25 4 245 25 4 245 25 6 4 5245 5 45 24 7 2 22 6 4 5245 8 4525 4 7 2 22 10 245 3 8 4525 4 11 45 45 9 2 4 14 3 24 10 245 3 11 45 45 12 3 4 13 445 3 14 3 24 15 245 5 Thanks! Ian |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting data
Welcome, Ian ! Thanks for feeding back.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "I. Miller" wrote: Max, thank you again! You also helped me with the Pivot Table advice yesterday. Cheers! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting data | Setting up and Configuration of Excel | |||
Sorting data to match existing data | Excel Discussion (Misc queries) | |||
sorting data with ; | Excel Discussion (Misc queries) | |||
colors of bar charted data don't follow data after sorting | Charts and Charting in Excel | |||
Help Help - Sorting Data | New Users to Excel |