View Single Post
 
Old 05-22-2017, 04:38 AM
edinn10 edinn10 is offline Windows 10 Office 2016
Novice
 
Join Date: May 2017
Posts: 6
edinn10 is on a distinguished road
Default How to sort in excel!?

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
Reply With Quote