How to display certain criteria only

[limewire]

Hi all,

Please see attached 'sample' player list. I am trying to figure out on how I can only display the different playing positions on their seperate tabs, but have these tabs more of a viewer. Changes will only be made in the main list.

I dont know if Im clear enough but hopefully Im understood

[limewire]

bump bump bump

[:) Sixthsense :)]

In A2 Cell of Goalkeepers,Defenders,Midfielders & Strikers Sheet - Array Formula Requires CTRL+SHIFT+ENTER

Please Login or Register  to view this content.

Drag it right upto column-D and down...