View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
EvasiveFox EvasiveFox is offline
external usenet poster
 
Posts: 1
Default How to Alphebetize one column, but keep next column together with

Hi all, I have a list of movie titles in one column and the CD number on
which the movie is found, in the next column. How do I sort the movie titles
by alphabetical name in column one, while keeping the disk number in the next
column together with the title, so that I know what disk it's on? I've been
trying to figure this one out for days now - please help :)

For example....

TITLES DISK #
Days of Thunder 1
Armegeddon 2
Jurassic Park 3

I would like it to look like

TITLES DISK #
Armegeddon 2
Days of Thunder 1
Jurassic Park 3

If anyone can figure this out, I'd really appreciate it - thanks!