View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arnie[_2_] Arnie[_2_] is offline
external usenet poster
 
Posts: 6
Default How to index teammembers within in a pool?

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?