group into columns

[d0wnt0wn]

is there any way that i can setup a sheet so that it will take all of the players in the first team and put them in a column.... then go to the next team and put them in the next column and so on... players will be added periodically but will always be sorted together. Here is an example of waht i have now


Dan Larocque 8_Ball_Magic
Kristin Ward 8_Ball_Magic
Linda Larocque 8_Ball_Magic
Sue Kelly 8_Ball_Magic
Vic Therrien 8_Ball_Magic
Cherie Seidler 8_Ball_Magic
Tammy McPhee 8_Ball_Magic
Mark Witts 8_Ball_Magic
Brent Iveson 8_Ball_Magic
Chrissy McEvoy 8_Ball_Magic
Cathy Masterman Check_The_Rack
Dianne Hoy Check_The_Rack
Felicity Wimperis Check_The_Rack
Ian Roberts Check_The_Rack
Karen Wong Check_The_Rack
Sue Fawcett Check_The_Rack
Kari Miller Check_The_Rack
Dave McEvoy Damn_Str8
Gord Gervais Damn_Str8

 

[Sal Paradise]

You can do it like this:

Use dynamic ranges and the like if you'd prefer.

Excel Workbook
	A	B	C	D	E	F
1	Dan Larocque	8_Ball_Magic		10	7	2
2	Kristin Ward	8_Ball_Magic		8_Ball_Magic	Check_The_Rack	Damn_Str8
3	Linda Larocque	8_Ball_Magic		Dan Larocque	Cathy Masterman	Dave McEvoy
4	Sue Kelly	8_Ball_Magic		Kristin Ward	Dianne Hoy	Gord Gervais
5	Vic Therrien	8_Ball_Magic		Linda Larocque	Felicity Wimperis
6	Cherie Seidler	8_Ball_Magic		Sue Kelly	Ian Roberts
7	Tammy McPhee	8_Ball_Magic		Vic Therrien	Karen Wong
8	Mark Witts	8_Ball_Magic		Cherie Seidler	Sue Fawcett
9	Brent Iveson	8_Ball_Magic		Tammy McPhee	Kari Miller
10	Chrissy McEvoy	8_Ball_Magic		Mark Witts
11	Cathy Masterman	Check_The_Rack		Brent Iveson
12	Dianne Hoy	Check_The_Rack		Chrissy McEvoy
13	Felicity Wimperis	Check_The_Rack
14	Ian Roberts	Check_The_Rack
15	Karen Wong	Check_The_Rack
16	Sue Fawcett	Check_The_Rack
17	Kari Miller	Check_The_Rack
18	Dave McEvoy	Damn_Str8
19	Gord Gervais	Damn_Str8
Sheet1

 

[d0wnt0wn]

looks great... illl try it later thanks

 

[d0wnt0wn]

ok i ran into a snag here...... when i enter the array the formula is what is shown in the cell... i have modified it a bit to suit me... did i do soemthing wrong... or is it that i am trying to do this from another sheet that is causing the prob

{=INDEX(main!$c14:$c250,MATCH(0,COUNTIF(main!$c14:$c250,"<"&main!$c14:$c250),0))}

 

[Sal Paradise]

What is the problem exactly? The formula looks right for D2, but you need to change the formulas for E2 and F2.

 

[d0wnt0wn]

im not sure what the problem is.... when i enter the formula.... the formula is visible in the cell not the result.... i have my player names in dk and my tream names in dl the formula was entered into dk2... are there any rules for indirect?? like you cant reference cells with formulas or anything likethat?

 

[d0wnt0wn]

heh i just realized what i did..... i copied your { from the website.... so it looked like an array but it was not


oops

thanks for the help