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?

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?