1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel Spreadsheet

Discussion in 'Business Applications' started by KimaliKy, Apr 27, 2008.

Thread Status:
Not open for further replies.
  1. KimaliKy

    KimaliKy Thread Starter

    Joined:
    Jan 9, 2008
    Messages:
    3
    I am setting up a spreadsheet for my classes, and I am wanting to see if there is a way to sort a column by male, female pattern. (I was hoping to be able to sort the list that way in order to prepare a seating chart....boy, girl, boy, girl etc...)

    ...I know that it will sort it by lumping the males together and then the females or vice versa... But I am hoping there is a way to be able to alternate the boys and girls.

    But before giving up I thought I would ask you all here, since you have been a big help in the past.

    Thanks in advance!!!

    =O)
    KimlaiKy
     
  2. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    You could have another Column where you have numbers pairing them.
    ie. Sort them Male/Female and then for the Males enter 1 for the first and 2 for the second and then drag that sequence down to the last male. The repeat that for the Females.
    Now sort by value first and then m/f and you should have boy, girl.
    I think.
    Actually you get Girl, Boy etc
    Make it G & B instead of F & M to get it as Boy Girl.

    The column with the values can of course be hidden.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/707777

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice