Make Poules with ABBA

Hello,

I want to make 2 poules.
There are members they give the rating to play with a game.
So i want to make 2 poules with ABBA on the rating.

For example.

member1 - 1000
Member2 - 2000
member3 - 3000
member4 - 4000
member5 - 1500
member6 - 2500
member7 - 3500
member8 - 4500

If you sort this on rating, you get:
member8 - 4500
member4 - 4000
member7 - 3500
member3 - 3000
member6 - 2500
Member2 - 2000
member5 - 1500
member1 - 1000

Now i want to make 2 poules:

Poule 1:
member8
member6
member3
member1

Poule 2:
member7
member5
member4
member2

How can i do that in Excel?
It must work from Excel 2007 and newer.

Thanks

Gr
Peter

I use ABBA

member8 - 4500 A
member4 - 4000 B
member7 - 3500 B
member3 - 3000 A
member6 - 2500 A
Member2 - 2000 B
member5 - 1500 B
member1 - 1000 A

The highest in poule1
the one after the highest in poule B
etc.