View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barry-Jon Barry-Jon is offline
external usenet poster
 
Posts: 17
Default sort and column numbers

Your question is a little confusing to be honest. If you sort the data
descending then the first column will contain the highest number and
not the third column. To sort from right to left highlight the row or
range to sort and choose Data - Sort from the menu under options
select the "Sort left to right" option under orientation then choose
Descending in the sort dialog.

What are you actually trying to accomplish?