Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Nov 2001
    Location
    Burbank, Illinois, USA
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting boy/girl (Excel 2002 SP3)

    Hello
    I work at a school distict and we are getting ready for 8th grade graduation. I had a request to make a report of all the eight graders in alphabetical order. That of course is no problem. My problem is not only do they want it in alphabetical order, but they would also like it to be boy, girl, boy, girl. An example of the request would be
    Adams, James (boy) Afash, Juanita (girl), Adams Robert (boy) Answer, Jane (girl).
    Is this possible to do? Any help you could give me will be greatly appreciated.
    Thanks in advance!

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting boy/girl (Excel 2002 SP3)

    A few questions:

    1- Are there exactly the same number of boys and girls, and if not what is supposed to happen if there is more of one than the other?

    2- Is there a column that indicates the sex of the student? If not, then the answer to your question is no, it can not be done. If the answer is yes, what column contains the name and what column contains the sex, and what is used to indicate the sex?

    3- Is this a one time thing that could be done with a set of manual steps, or do you need an automated solution using VBA?

    4- Should the list start with a boy or a girl?
    Legare Coleman

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Sorting boy/girl (Excel 2002 SP3)

    As a basic approach:

    Sort the list first by boys/girls then lastname, then first name (A has names, B has sex)
    Assume after sort Boys are A1:A100, girls A101 to A200
    make of list in a column of 1 - 100 (the number of boys), followed by a list of 1 -100(#girls) for example in c1 to c200)
    Now sort by col C (number), then by col B (sex) and you have your list.

    Steve

  4. #4
    Star Lounger
    Join Date
    Nov 2001
    Location
    Burbank, Illinois, USA
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting boy/girl (Excel 2002 SP3)

    Thank you very much that worked great!! You are wonderful!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •