sorting data

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.
 
B

BobT

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.
 

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

Top