Sorting groups of info

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

Guest

I need help sorting groups of information. I have about 15 groups of data each 5 columns wide and a length that varies between 5-10 rows. Each group's title is in the 3rd column. Is there any way that I can sort the groups of data ascending by their titles (without having to reformat the group of data?

Thanks!
 
Hi, Sue,

If by "Each group's title is in the 3rd column." you mean
that the title looks like a heading and is not embedded
in the data, then I don't believe there's an easy way to
sort the groups short of copying that title down in some
out-of-the-way column for each record and use that to
sort by....

jeff
-----Original Message-----
I need help sorting groups of information. I have about
Click to expand...
15 groups of data each 5 columns wide and a length that
varies between 5-10 rows. Each group's title is in the
3rd column. Is there any way that I can sort the groups
of data ascending by their titles (without having to
reformat the group of data?)
 

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

Analysing different groups of data in the same column 1
Grouping Cells / Sorting 1
Sort blocks of data 1
Sorting Groups of Rows 1
Getting Text data using the Data - Subtotal feature 1
Auto filter columns while keeping groups of verticle cells togethe 1
Print Landscape/Portrait based on level of grouped data selected 4
How to sort when I have multiple header rows (not included in sor. 1

Back
Top