+ Reply to Thread
Results 1 to 3 of 3

Challenge for everyone - Sort a text list adding a count in the bottom of each group. :)

  1. #1
    Registered User
    Join Date
    10-08-2013
    Location
    Australia
    MS-Off Ver
    Office for Mac 2011
    Posts
    3

    Challenge for everyone - Sort a text list adding a count in the bottom of each group. :)

    Hello everyone

    I know you're all busy so i'll keep it as brief as possible, I have a challenge that i haven't been able to solve for a while besides doing it manually which i'm estimating would take a year at least. I've searched the net and this forum and came up empty. So what i'd like to do put all the make and models into a group with a total at the bottom and them sort them with the highest performer to the lowest performer

    I.E from this:

    Toyota Corolla
    Toyota Corolla
    Toyota Corolla
    Toyota Corolla
    Toyota Camry
    Toyota Camry
    Toyota Camry
    Toyota Camry
    Toyota Camry
    Holden Astra
    Holden Astra
    Holden Astra
    Holden Astra
    Holden Astra
    Holden Astra
    Holden Astra

    To:
    Holden Astra
    Holden Astra
    Holden Astra
    Holden Astra
    Holden Astra
    Holden Astra
    Holden Astra
    Total 7

    Toyota Camry
    Toyota Camry
    Toyota Camry
    Toyota Camry
    Toyota Camry
    Total 5

    Toyota Corolla
    Toyota Corolla
    Toyota Corolla
    Toyota Corolla
    Total 4

    Is this possible?

    Also is there a way to sort and place into a new sheet from this
    http://www.excelforum.com/attachment...9.08.54-pm.jpg
    Which has been ordered by year, then in the second column by month i.e 2 = February

    and placed into a new sheet that looks like this

    http://www.excelforum.com/attachment...9.07.48-pm.jpg

    Where you can see all the January or "1" have been put together from the years of 2008 to 2013 and placed side by side for comparison.

    Then the above formula to group all the makes and models and have a tally should be added to have the top performers at the top.

    I've attached a sample before and after i hope this helps I look forward to hearing from you soon. Thank you again for everything.


    Thank you so much everyone I really appreciate your help, I hope to hear from you all soon as I'll be using this for a uni assignment and my lecturer is stumped.


    Thanks again.

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,593

    Re: Challenge for everyone - Sort a text list adding a count in the bottom of each group.

    Have you tried pivot tables?

  3. #3
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,757

    Re: Challenge for everyone - Sort a text list adding a count in the bottom of each group.

    To arrive at the presentation you have above, sort your column alphabetically, then apply the sub-totals function. I have a PC and am not familiar with the UI for a MAC. But in earlier versions of the PC application, it is under Data. This will apply the counts after every change in topic.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 10-21-2013, 11:36 PM
  2. [SOLVED] Conditional Format to draw top and bottom borders at first and last of a group of text
    By jojo101 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-21-2013, 02:17 AM
  3. Replies: 1
    Last Post: 10-19-2012, 07:55 AM
  4. Sort list and put blank cells to bottom
    By JamesT1 in forum Excel General
    Replies: 2
    Last Post: 05-19-2011, 11:27 AM
  5. How to sort dashes to the bottom of the list
    By jmdelivery29 in forum Excel General
    Replies: 1
    Last Post: 05-11-2009, 06:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1