Thread: Sorting columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tom
 
Posts: n/a
Default Sorting columns

This is probably pretty standard but how to I sort columns containing the
same data but in different orders. eg. Column A has 1-10 listed in ascendinf
order, and column B has them listed in descending order, how could I sort
them so that 1 and 1, 2 and 2 etc pair up?