Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Match values from two columns
Hi
I have two tables with a number as common key. The first table contains a subset of the numbers in table 2. I like to sort the rows in the seccond list based on the matching the number in the first list. How to do it in Excel 2000 ?? examle: table 1 table 2 Result Number1 | Name Number2 | Price Number1|Price |
#2
|
|||
|
|||
Hi
not really sure how you want to sort. Do you want the matching values in table 2 at the top?? -- Regards Frank Kabel Frankfurt, Germany "pek" schrieb im Newsbeitrag ... Hi I have two tables with a number as common key. The first table contains a subset of the numbers in table 2. I like to sort the rows in the seccond list based on the matching the number in the first list. How to do it in Excel 2000 ?? examle: table 1 table 2 Result Number1 | Name Number2 | Price Number1|Price |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I match values? | Excel Worksheet Functions | |||
how to build a formula to match numbers in 2 columns with the equ. | Excel Worksheet Functions | |||
How do i Match all COLUMNS? | Excel Worksheet Functions | |||
HOW TO MATCH MULTIPLE COLUMNS WITH OR WITHOUT GAPS IN eXCEL ? | Excel Worksheet Functions | |||
Need to sum values of columns 1 - 13 and 4 - 15 | Excel Worksheet Functions |