Re: Re: Fancy(?) sorting
From: Earl Kiosterud (nowhere_at_nowhere.com)
Date: 03/11/04
- Next message: Will Fleenor: "Character to prevent rows from printing"
- Previous message: Carl Brehm: "Re: Rounding"
- In reply to: bt: "Re: Re: Fancy(?) sorting"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 11 Mar 2004 00:06:50 -0500
bt,
I don't think there's any Excel command that will do what you want. Excel
works with standard tables, where there is one set of headings, and one row
per item (as with the example I gave you of a consolidated list). You could
still set it up the way I suggested (add a Musician column, and put the
musician name in each of his/her rows), and hide that column. It wouldn't
take long using the Fill Handle. Sorting the table on that column would
give you the results you want. It would leave the songs in their original
order in each musician's section. This won't give you the section titles
("Musician W") you currently have, though.
If you want to do it by hand, select all the rows of a musician's section,
including it's heading (drag through the row headers at the left). Then
grab this stuff by the border, hold Shift, and drag the insert bar to
wherever it belongs. This allows you to move a section, make room elsewhere
for it, and delete the hole you left behind.
Or you can cut each section, then use the right mouse key, and "Insert cut
cells" to put it elsewhere.
-- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "bt" <bt@.com> wrote in message news:atqv40577v8vl6oob7ur67ddhaebrcdic1@4ax.com... > > > On Wed, 10 Mar 2004 23:21:45 -0500, "Earl Kiosterud" > <nowhere@nowhere.com> wrote: > > >bt, > > > >This sounds like one big table, which you want to sort on your "list" > >column. Select the two columns, Data - Sort. Be sure to indicate whether > >you have a heading row (one, at the top) or not. Examine the results > >carefully, and if it's not what you want, you can undo it. Do not save the > >file until you are certain the sort was valid. Excel is capable of turning > >a good list into garbage. > > Yes, this would work, except that the name of the list is not carried > down to each row in the list. It is only on the top row which is the > row above the items in the list. > > > >If each of your lists has it's own headings, this won't work. You'll have > >to sort them individually. > > No headings, each list is formated the same although the number of > items varies. > > > >If you post back, say more about your lists. All in one sheet? Give some > >examples of your data. > > All in one sheet. Here is what it looks like (I said it was simple): > > Musician W > song 1 > song 2 > .. > .. > song 23 > > Musician B > song 1 > song 2 > .. > .. > song 25 > > Etc. > > > For any given musician, the songs are in the desired order, but > unfortunately, the musicians have been added somewhat arbitrarily over > time and I want to organize them alphabetically. > > thanks, BDT
- Next message: Will Fleenor: "Character to prevent rows from printing"
- Previous message: Carl Brehm: "Re: Rounding"
- In reply to: bt: "Re: Re: Fancy(?) sorting"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
