# group into columns

#### d0wnt0wn

##### Well-known Member
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

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
You can do it like this:

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

Excel Workbook
ABCDEF
1Dan Larocque8_Ball_Magic1072
2Kristin Ward8_Ball_Magic8_Ball_MagicCheck_The_RackDamn_Str8
3Linda Larocque8_Ball_MagicDan LarocqueCathy MastermanDave McEvoy
4Sue Kelly8_Ball_MagicKristin WardDianne HoyGord Gervais
5Vic Therrien8_Ball_MagicLinda LarocqueFelicity Wimperis
6Cherie Seidler8_Ball_MagicSue KellyIan Roberts
7Tammy McPhee8_Ball_MagicVic TherrienKaren Wong
8Mark Witts8_Ball_MagicCherie SeidlerSue Fawcett
9Brent Iveson8_Ball_MagicTammy McPheeKari Miller
10Chrissy McEvoy8_Ball_MagicMark Witts
11Cathy MastermanCheck_The_RackBrent Iveson
12Dianne HoyCheck_The_RackChrissy McEvoy
13Felicity WimperisCheck_The_Rack
14Ian RobertsCheck_The_Rack
15Karen WongCheck_The_Rack
16Sue FawcettCheck_The_Rack
17Kari MillerCheck_The_Rack
18Dave McEvoyDamn_Str8
19Gord GervaisDamn_Str8
Sheet1

looks great... illl try it later thanks

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))}

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

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?

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

1,207,094
Messages
6,076,549
Members
446,212
Latest member
KJAYPAL200

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back