View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kevincanuk kevincanuk is offline
external usenet poster
 
Posts: 6
Default Simple sort Problem

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????