Solved

Sort column based on volume

Posted on 2011-03-03
4
365 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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

This article will show you how to use shortcut menus in the Access run-time environment.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

730 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