Creating Groups.

[Belleke]

See example, explanation is in the file.
Sorry, forgot to tell, new draw (F9?) should give new groups, but not the participands that already been chosen.
Thanks.

 

[Belleke]

Bump.
Is there a VBA solution?

 

[vletm]

Belleke​

One long sample version ...

 

[Belleke]

Hoi vletm,
It looks like it is working fine but I would like to add the values
See example for group 1 and 2 in columns W-> AK
Thanks in advance.

 

[vletm]

... but ... like ...
or
Something like this?
Which You could modify as You like

 

[Belleke]

Hi vletm
Looks perfect, but why these comments?

 

[vletm]

Those are almost ready for Your next steps.

 

[Belleke]

I have a problem with your new example, when I add a new participant it doesn't show uo in grouping or value.
the comments are not a problem.

 

[Belleke]

Sorry vletm, I found it.
I will test it further, Il keep you informed.

 

[vletm]

... I tested it one way with 200 rows of data.