Home |
Search |
Today's Posts |
#1
|
|||
|
|||
divide a large group of people into smaller groups by their vote
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. |
#2
|
|||
|
|||
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 "siku" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to group several items in different groups to be placed in a c | Excel Discussion (Misc queries) | |||
Need help w/ Weight Formula | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Working with a large group of numbers | Excel Worksheet Functions |