Solved

Sort column based on volume

Posted on 2011-03-03
4
362 Views
Last Modified: 2012-05-11
Hello experts

I am trying to sort a list of email addresses based on the quanitity (hi/lo) rather than by A/Z but I can't work out how to do this.

Crude example, If these are my addesses:
carol
adam
ben
carol
denise
adam
ben
carol

Sorting A/Z will place adam at the top, I want to search on the highest number of occurances (which would be carol)

Can you help?
Thanks
0
Comment
Question by:wisemat
  • 2
4 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 35025837
Use a formula in an additional column like:
=COUNTIF(A:A,A1)
to get the number of occurrences for each, then sort on that column.
0
 

Author Closing Comment

by:wisemat
ID: 35025893
Simple and perfect

Thank you
0
 
LVL 4

Expert Comment

by:Sajen_Jose
ID: 35025919
Hi,

I would do a quick pivot table and sort by volume. Check the attached excel file Test.xls

http://www.techonthenet.com/excel/pivottbls/create.php - This link would guide you step by step, once you create the pivot table sort by count and it should give you the answer you are looking for.
0
 

Author Comment

by:wisemat
ID: 35025939
Thanks very much, turns out pivot tables aren't as complicated as I originally thought :)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
Outlook Free & Paid Tools
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now