To Separate the men from the women

[americanpie3]

I know how the title sounds LOL.

I play in a mixed dart league. I have a page that has stats of the highest scorers but they are mixed.

I would need a suggestion where in 1 column I have all the players in which I sort from highest scorers from the week and in my results page I can have 1 section for top 5 scoring men and top 5 scoring women.

How can I do this?

Cheers

 

[sheetspread]

The pivot table does this

 

[americanpie3]

How?

I am not familiar with pivot tables.

 

[joeu2004]

I know how the title sounds LOL

Yes. My first reaction was =RIGHT(A1,3), where A1 is "women".

 

[sheetspread]

How?

I am not familiar with pivot tables.

Something like:

(2 tables)