Sort a range of data based on another column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining information from two excel list 3
combining and sorting data from two workbooks 4
Removing parts of Data in a Cell / [], # 2
Compare two columns for typos 6
Sorting within Rows 7
Why can't this table be sorted? 3
data prints outside column 2
Greater than less than total in a column 1

Back
Top