+ Reply to Thread
Results 1 to 2 of 2

Can't figure out how to sort groups of data

  1. 05-01-2012, 11:42 AM #1
    Sathed
    Sathed is offline
    Registered User
    Join Date
    02-22-2008
    Location
    Utah
    Posts
    10

    Can't figure out how to sort groups of data

    As the title says, I'm trying to sort groups of data. However, I'm trying to sort by the size of the group.

    For example:

    Please Login or Register  to view this content.
    This should sort to:

    Please Login or Register  to view this content.
    I'm assuming VB will be required. Can anyone point me in the right direction?
    Reply With QuoteRegister To Reply
  2. 05-01-2012, 11:51 AM #2
    JieJenn
    JieJenn is offline
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Can't figure out how to sort groups of data

    use countif to get the quantity of each item, then sort by the quantity
    Attached Files Attached Files
    Learn Data Analysis or Excel youtube.com/jiejenn
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1