Maybe it's because I don't play golf, but ... I don't have the slightest
idea what you're talking about.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Arnie" wrote in message
el.net...
Sorry,

Sure I can:

PlayerID Pool Name
1 1 John
2 1 Pete
3 2 Jill
4 2 Fred
5 2 Ginger
6 3 Tony
etc.

The result should be something like this:
PlayerID Pool Name Id
1 1 John 1_1
2 1 Pete 1_2
3 2 Jill 2_1
4 2 Fred 2_2
5 2 Ginger 2_3
6 3 Tony 3_1
etc.


(to make more clear what I'm trying to accomplish: I have a form that I
want to print with 2 golfscorecards on it. If the are 2 players in a
pool/flight then player 1_1 has marker 1_2, but if there are 3 players in
a flight player 2_1 has marker 2_2, player 2_2 has marker 2_3 and player
2_3 has marker 2_1, etc. I want to sort out all the players and create a
dataset that is usefull to print the scorecards. Since the pools/flights
are variable it is difficult to find a way to print the scorecards.

Arnie

"Ragdyer" schreef in bericht
...
Don't follow what you're trying to accomplish.

Can't you make a simple datalist?
Names in Column A, ID number in adjacent row in Column B.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Arnie" wrote in message
bel.net...
Hi,

Here's what i'm trying to do:
I have abouth 50 players manualy divided over several teams. Each team
has
1-4 players. I want to give each player a unique identifier within the
teams. So player John in team 5 which consist 4 teammembers has id 5_1,
Pete
in the same team has id 5_2

I tried it with index, but the formula gives the value not te index of
the
selection.

Any ideas?