View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default Can I sort by more than 3 columns?

One way to do this is to insert a "helper" column and insert a formula
that concatenates each value from the 6 columns to a single cell, like
this:
=A2&B2&C2&D2&E2&F2

Copy and paste that cell into all the necessary rows, sort on your
helper column, and delete it.