sorting data

  • Thread starter Thread starter JoeM
  • Start date Start date
J

JoeM

Column A is id#, Column B is a sub category of this number. Column C is a
smaller list of duplicates from Column B. I need to get the numbers in column
C to match up with the corrosponding numbers in Column B without disrupting
the relationship that Column B has to Column A to show wich numbers in the
third list appear in the second list and it also needs to show what ID# it is
a sub category of.
 
So your data is like this:

2 22 222
1 11 111
3 34 341
1 11 112
3 33 331
5 55 551
4 44 441

And you'd like it like this:

1 11 111
1 11 112
2 22 222
3 33 331
3 34 341
4 44 441
5 55 551

If this is correct, then simply highlight all of the data (all three
columns) and from the DATA menu, choose SORT. Then sort based on Column A,
then by Column B, then by Column C and click on the OK button.
 
Back
Top