Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating groups of people with different background
Hi there I am working on a grouping for kids, so that I can make a
list of 8 kids with different backgrounds. There are about 400 kids at the camp, very busy. When they enroll, I receive a list with: enrollmentnumber, surname, prefix,initials, first_name, interest I would like to make groups of this list by sorting on their interest, so that I can spread out different interests over multiple groups. Example: Interest; raffting, cycling, swimming, woodwork, climbing, football, other Most assignments during the camp days are in groups, in addidtion I would like to give the group a letter starting with A untill for example AA or A1. The result shoud look like: Group, enrollmentnumber, surname, prefix,initials, first_name, interest A 00001 Simpson von dutch Bart cycling A 00044 Simpson von dutch Lisa football A B 00003 etc B Any suggestions, help is very welcome. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating groups of people with different background
a pivot table would work for you perhaps?
"frenchez" wrote in message ... Hi there I am working on a grouping for kids, so that I can make a list of 8 kids with different backgrounds. There are about 400 kids at the camp, very busy. When they enroll, I receive a list with: enrollmentnumber, surname, prefix,initials, first_name, interest I would like to make groups of this list by sorting on their interest, so that I can spread out different interests over multiple groups. Example: Interest; raffting, cycling, swimming, woodwork, climbing, football, other Most assignments during the camp days are in groups, in addidtion I would like to give the group a letter starting with A untill for example AA or A1. The result shoud look like: Group, enrollmentnumber, surname, prefix,initials, first_name, interest A 00001 Simpson von dutch Bart cycling A 00044 Simpson von dutch Lisa football A B 00003 etc B Any suggestions, help is very welcome. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
placing people into age groups based on their DOB | Excel Worksheet Functions | |||
Creating groups of people with different background | Excel Programming | |||
Creating evenly proportioned groups | Excel Discussion (Misc queries) | |||
creating groups based upon correlations | Excel Worksheet Functions | |||
divide a large group of people into smaller groups by their vote | Excel Discussion (Misc queries) |