Thread: Sorting columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joyce Joyce is offline
external usenet poster
 
Posts: 106
Default Sorting columns

Hi,

I have about 26 columns and every column has about 50 rows with similar
values (#'s). I want to sort the columns out in groups so i know which ones
have the most similar values.

Everytime i sort them out the column's values mix up and i no longer know
which value belongs to which column.

I tried to give every column a diferent color and then sort out the every
row at a time from smallest to largest. I'm sure there is a much easier way
to sort out the the entire columns with out mixing up the values that each
one has.

Help?!