Solved

Sort column based on volume

Posted on 2011-03-03
4
368 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

688 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