| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort a range of data based on another column
First column is a master part number list.
Second and third colums contain random part numbers and their quanties.How can Isort the second and third colums together o match the first column? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort a range of data based on another column
When you sort, First select all the cells in all columns/rows that have data
to be sorted, then do your sort based on column A. Excel will automatically move contents of 2nd and 3rd (B and C) to remain associated with the proper value in the sorted column (A). "RobM" wrote: First column is a master part number list. Second and third colums contain random part numbers and their quanties.How can Isort the second and third colums together o match the first column? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I sort a worksheet based on one column? | New Users to Excel | |||
| formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
| Dynamic column chart - auto sort on data range | Charts and Charting in Excel | |||
| EXCEL Sum column based on time range in different column? | Excel Worksheet Functions | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Linear Mode
