Need INDEX MATCH formula that arranges Xs in bottom rows and then starts arranging ys

I have an automated seating chart for my English class in China but I want to add something to take the existing chart and rearrange it below to make it so that it will put boys in the front and then girls in back (It just works better this way in oral English class). The formulas and sheets are much more complicated and bigger than the following example and there are good reasons I can't change my example to make things easier.
There is also more detailed info about what I want in the excel file.rearrange stng chrt.xls
By the way, I'm still using Excel 97.
Thanks in advance for your help,
Brant

I found a solution myself. I suppose I limited answers by saying I couldn't change anything to make it easier. In the attendance sheet I made a new list offscreen with the students names in one column and the genders in the next column, then I sorted the cells based on the gender column so that the males were on top. Then in my seating chart sheet I put a formula that linked the first seat in the front row to the cell with the first name in the attendance sheet, then the second seat in the first row to the cell with the second name and so on. Depending on how many boys there are I could end up with a boy sitting next to a girl but I could manually just move one girl farther back very quickly. The formula in the first row of the seating chart would be something like this

Please Login or Register  to view this content.

where $BI$1 would have the first boys name