divide a large group of people into smaller groups by their vote

[Guest]

I need to divide a large group of people into smaller groups by their vote.
They individually vote whom they wish to be in a sub-group with and the
chart would form the sub-groups.

 

[Guest]

In A1 type NAME
In B1 type SUBGROUP
Starting in A2, fill in the rest of the sheet with all the names of your
folks and how they voted, down columns A and B

Then, select both columns by highlighting the A and B at the top of the
columns., then in the upper ToolBar, click Data > Sort > select column B
ascending for the first key, and column A ascending for the second key then
"OK"

This should sort your list by "vote" and alphabetize each subgroup.

Give it a try and post back if you run into problems......

Vaya con Dios,
Chuck, CABGx3