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.

a pivot table would work for you perhaps?

"frenchez" <(E-Mail Removed)> wrote in message
news:9274E134-3225-4DC4-832C-(E-Mail Removed)...
> 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.

select the top row>data>filter>autofilter>filter on the interest column

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"frenchez" <(E-Mail Removed)> wrote in message
news:9274E134-3225-4DC4-832C-(E-Mail Removed)...
> 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.