Simple sort Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Click on all 3 column letters, to select the columns.
Data>Sort>Sort by column A Descending >then by column C descending.

If you have headers in row 1, ensure the header row is clicked, and
instead of column letters, you will see the header name as the Sort by
options.
 
Sort by
1. Sex/ascending
2. Percent/descending

Regards,
Stefi

„kevincanuk†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pull out certain data 1
Chart from 1 Column 1
excel 1
Summing data in columns 2
More formula problems 7
Setting multiple conditions to return a figure from multiple cells 4
Referencing the values returned by a formula 3
Counting more than one criteria 4

Back
Top