[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 385
  • Last Modified:

Sort column based on volume

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
wisemat
Asked:
wisemat
  • 2
1 Solution
 
Rory ArchibaldCommented:
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
 
wisematAuthor Commented:
Simple and perfect

Thank you
0
 
Sajen JoseCommented:
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
 
wisematAuthor Commented:
Thanks very much, turns out pivot tables aren't as complicated as I originally thought :)
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now