How to sort in excel!?

[edinn10]

Hi there,

Hope you are doing well,
I have a problem with sorting in excel, As you can si in a screenshoot below I have an excel file with some colons, and last one is " MailServerCountryCode" you see "US, KR, JP, etc ("I have also a lot of this, but this is as demo" )

Problem: I want to sort from this colon "MailServerCountryCode" I want to separate only 5 people from Colon" MailServerCountryCode " US, KR, JP, etc

So 5 people from mail server US 5 from KR 5 from JP, after this sort to continue the same sort 5 by 5 but not those which we sort only others below and below till finish.
Hope it's clear.

I know it's a big problem hope you can help me.



PS. One solution is to select the colon" MailServerCountryCode " and te click remove duplicates then people from them to separate on another group than to go again remove duplicates and again remove duplicates but this takes tame and needs manually to do that.

File -> https://drive.google.com/a/ubt-uni.n...ew?usp=sharing