tagging rows to columns???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

john smith - 30 Dec 2004 01:20 GMT

I just created an excel catalog for my cd jukebox as I loaded the tray (300
discs). Now I want to alphabetize column A (artist) and have column B
(album title) follow column A. Is there a way to do this?

Thanks for all help.
beo

Reply to this Message

Max - 30 Dec 2004 01:47 GMT

Try on a duplicate copy of your sheet:

Assuming your lists are in cols A and B,
data from row2 down, viz.:

Artist Title
ABC Text1
XYZ Text2
DEF Text3
etc

Select cols A and B

Click Data > Sort

Check "Header row" under "My list has"

Ensure settings
under "Sort by" are: Artist > Ascending

Click OK

For the sample data above, you'll get:

Artist Title
ABC Text1
DEF Text3
XYZ Text2

Signature

--
Rgds
Max
xl 97
---
GMT+8, 1? 22' N 103? 45' E
xdemechanik <at>yahoo<dot>com
----

> I just created an excel catalog for my cd jukebox as I loaded the tray (300
> discs). Now I want to alphabetize column A (artist) and have column B
> (album title) follow column A. Is there a way to do this?
>
> Thanks for all help.
> beo

Reply to this Message

Ken Wright - 30 Dec 2004 09:12 GMT

Just make sure you select the entire range of data before you sort, ie Col A AND
Col B, AND any other columns that contain data

Signature

Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

>I just created an excel catalog for my cd jukebox as I loaded the tray (300
>discs). Now I want to alphabetize column A (artist) and have column B (album
>title) follow column A. Is there a way to do this?
>
> Thanks for all help.
> beo

Reply to this Message