Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-22-2017, 04:38 AM
edinn10 edinn10 is offline How to sort in excel!? Windows 10 How to sort in excel!? Office 2016
Novice
How to sort in excel!?
 
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
  #2  
Old 05-22-2017, 08:22 AM
NoSparks NoSparks is offline How to sort in excel!? Windows 7 64bit How to sort in excel!? Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Not clear to me.

Your best shot at a solution would be to attach a file here in the forum with two sheets, the first being the sheet you picture as the example and the second being what you want the results to be.

Have you tried using the macro recorder to record the 'one solution is' that you describe ?

Please include links to your cross posts.
http://www.excelguru.ca/content.php?184
Reply With Quote
  #3  
Old 05-22-2017, 08:53 AM
edinn10 edinn10 is offline How to sort in excel!? Windows 10 How to sort in excel!? Office 2016
Novice
How to sort in excel!?
 
Join Date: May 2017
Posts: 6
edinn10 is on a distinguished road
Default

NoSparks thank you,

VIDEO - https://streamable.com/irtu5


This si one solution, but as you may see I get only 5 or 10 contacts unique from this method, and to do it, again and again, takes time I need this to be more easy, to get Uniques,

Also, this solution is only for one US one for KR. I need 5 by 5 for each one,

Hope you understand now,

Thank you.
Reply With Quote
  #4  
Old 05-23-2017, 12:36 PM
NoSparks NoSparks is offline How to sort in excel!? Windows 7 64bit How to sort in excel!? Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Your title says sort but I don't see anything being sorted.

It appears your desire is to display the first 5 records of filtered data.
If so, you'll need them copied to a different sheet.
Is that what you're after ?
Reply With Quote
  #5  
Old 05-23-2017, 12:39 PM
edinn10 edinn10 is offline How to sort in excel!? Windows 10 How to sort in excel!? Office 2016
Novice
How to sort in excel!?
 
Join Date: May 2017
Posts: 6
edinn10 is on a distinguished road
Default

NoSparks Yes, or to be more accurate, 1 need first unique values, then again unique values under first one.
Reply With Quote
  #6  
Old 05-23-2017, 02:27 PM
NoSparks NoSparks is offline How to sort in excel!? Windows 7 64bit How to sort in excel!? Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

What is your definition of unique ?
Each record has 9 fields, what determines unique ?

Your sample data has 307 records with CountryCode KR, how do you determine which 5 to display ?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to sort in excel!? Unable to sort dates in Excel on new PC freebird795 Excel 3 12-07-2014 03:06 PM
EXCEL will not sort texascpa Excel 6 04-17-2013 07:58 AM
sort data in excel cabot Excel 1 08-17-2012 09:41 AM
How to sort in excel!? Is this sort of pivot possible in the Excel? Jamal NUMAN Excel 4 02-14-2012 02:48 PM
Excel sort problem jaz Excel 2 01-16-2011 04:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft