View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Simple sort Problem

Sort by
1. Sex/ascending
2. Percent/descending

Regards,
Stefi

€˛kevincanuk€¯ ezt Ć*rta:

I am trying to sort a simple 3 column list, consisting of acolumn containing
M or F for Male Female, Name and a percentage value. I want to be able to
sort so that all of the m's are grouped together and their & value displayed
in decending value. And like wize all of the F's. The I can copy the top 5
Male scores and the top 5 female scores to the appropriate report page. I
have tried using the sort function but can't seem to get it to work properly.
Can anyone help????