Searching for players in a particular position

Steviefiege

Board Regular
Joined
Aug 29, 2018
Messages
66
Hi,
I have a list of players & their positions:

[TABLE="width: 277"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Alcock, Craig[/TD]
[TD]Full Back (Right)[/TD]
[/TR]
[TR]
[TD]Alcock, Craig[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Alcock, Craig[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Alcock, Craig[/TD]
[TD]Full Back (Left)[/TD]
[/TR]
[TR]
[TD]Anderson, Tom[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Anderson, Tom[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Andrew, Danny[/TD]
[TD]Full Back (Left)[/TD]
[/TR]
[TR]
[TD]Baudry, Mathieu[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Baudry, Mathieu[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Beestin, Alfie[/TD]
[TD]Advanced Playmaker[/TD]
[/TR]
[TR]
[TD]Beestin, Alfie[/TD]
[TD]Inside Forward (Left)[/TD]
[/TR]
[TR]
[TD]Beestin, Alfie[/TD]
[TD]Attacking Midfielder[/TD]
[/TR]
[TR]
[TD]Beestin, Alfie[/TD]
[TD]Inside Forward (Right)[/TD]
[/TR]
[TR]
[TD]Ben Khemis, Issam[/TD]
[TD]Advanced Playmaker[/TD]
[/TR]
[TR]
[TD]Blair, Matty[/TD]
[TD]Full Back (Right)[/TD]
[/TR]
[TR]
[TD]Boyle, Andy[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Boyle, Andy[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Butler, Andy[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Butler, Andy[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Coppinger, James[/TD]
[TD]Advanced Playmaker[/TD]
[/TR]
[TR]
[TD]Coppinger, James[/TD]
[TD]Attacking Midfielder[/TD]
[/TR]
[TR]
[TD]Coppinger, James[/TD]
[TD]Inside Forward (Right)[/TD]
[/TR]
[TR]
[TD]Evina, Cedric[/TD]
[TD]Full Back (Left)[/TD]
[/TR]
[TR]
[TD]Garrett, Tyler[/TD]
[TD]Full Back (Left)[/TD]
[/TR]
[TR]
[TD]Houghton, Jordan[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Houghton, Jordan[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Houghton, Jordan[/TD]
[TD]Advanced Playmaker[/TD]
[/TR]
[TR]
[TD]Kiwomya, Alex[/TD]
[TD]Inside Forward (Left)[/TD]
[/TR]
[TR]
[TD]Kiwomya, Alex[/TD]
[TD]Attacking Midfielder[/TD]
[/TR]
[TR]
[TD]Kiwomya, Alex[/TD]
[TD]Inside Forward (Right)[/TD]
[/TR]
[TR]
[TD]Kiwomya, Alex[/TD]
[TD]Advanced Forward[/TD]
[/TR]
[TR]
[TD]Kongolo, Rodney[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Kongolo, Rodney[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Kongolo, Rodney[/TD]
[TD]Advanced Playmaker[/TD]
[/TR]
[TR]
[TD]Kongolo, Rodney[/TD]
[TD]Attacking Midfielder[/TD]
[/TR]
[TR]
[TD]Lawlor, Ian[/TD]
[TD]Goalkeeper[/TD]
[/TR]
[TR]
[TD]Lund, Mitchell[/TD]
[TD]Full Back (Right)[/TD]
[/TR]
[TR]
[TD]Lund, Mitchell[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Lund, Mitchell[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Mandeville, Liam[/TD]
[TD]Attacking Midfielder[/TD]
[/TR]
[TR]
[TD]Mandeville, Liam[/TD]
[TD]Advanced Forward[/TD]
[/TR]
[TR]
[TD]Marosi, Marko[/TD]
[TD]Goalkeeper[/TD]
[/TR]
[TR]
[TD]Marquis, John[/TD]
[TD]Advanced Forward[/TD]
[/TR]
[TR]
[TD]Mason, Niall[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Mason, Niall[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Mason, Niall[/TD]
[TD]Full Back (Right)[/TD]
[/TR]
[TR]
[TD]Mason, Niall[/TD]
[TD]Full Back (Left)[/TD]
[/TR]
[TR]
[TD]Mason, Niall[/TD]
[TD]Advanced Playmaker[/TD]
[/TR]
[TR]
[TD]May, Alfie[/TD]
[TD]Inside Forward (Left)[/TD]
[/TR]
[TR]
[TD]May, Alfie[/TD]
[TD]Inside Forward (Right)[/TD]
[/TR]
[TR]
[TD]May, Alfie[/TD]
[TD]Advanced Forward[/TD]
[/TR]
[TR]
[TD]McCullough, Luke[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]McCullough, Luke[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]McCullough, Luke[/TD]
[TD]Advanced Playmaker[/TD]
[/TR]
[TR]
[TD]Rowe, Tommy[/TD]
[TD]Advanced Playmaker[/TD]
[/TR]
[TR]
[TD]Rowe, Tommy[/TD]
[TD]Full Back (Left)[/TD]
[/TR]
[TR]
[TD]Rowe, Tommy[/TD]
[TD]Inside Forward (Left)[/TD]
[/TR]
[TR]
[TD]Whiteman, Ben[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Whiteman, Ben[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Whiteman, Ben[/TD]
[TD]Advanced Playmaker[/TD]
[/TR]
[TR]
[TD]Williams, Andrew[/TD]
[TD]Inside Forward (Left)[/TD]
[/TR]
[TR]
[TD]Williams, Andrew[/TD]
[TD]Inside Forward (Right)[/TD]
[/TR]
[TR]
[TD]Williams, Andrew[/TD]
[TD]Advanced Forward[/TD]
[/TR]
[TR]
[TD]Wright, Joe[/TD]
[TD]Central Defender[/TD]
[/TR]
[TR]
[TD]Wright, Joe[/TD]
[TD]Defensive Centre Back[/TD]
[/TR]
[TR]
[TD]Wright, Joe[/TD]
[TD]Full Back (Right)
[/TD]
[/TR]
</tbody>[/TABLE]

How do i for example, make a list of everyone who plays in Central Defender?

Rgs
Steve
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
I want it seperate though, for example in another sheet, i'll have my position at the top (Goalkeeper), then underneath that, all the players that can play there. Like in my example below:

Goalkeeper FB (Right)

Lawlor, Ian Alcock, Craig
Marosi, Marko Blair, Matty

etc....
 
Upvote 0

Forum statistics

Threads
1,224,814
Messages
6,181,125
Members
453,021
Latest member
Justyna P

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top