+ Reply to Thread
Results 1 to 1 of 1

How to put grouped data in ascending order in excel and then concatenate

  1. #1
    Registered User
    Join Date
    07-11-2012
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    1

    How to put grouped data in ascending order in excel and then concatenate

    I have parent and child accounts that make a family. If the Parent_acct = Accnt_no then its parent account and others are child account. Associated with it is the Fee and Internal_acct_no for each account. The problem is how to concatenate the Fee in the family (same Parent_acct_no make a family) with "," ordering the result in ascending order of Internal_acct_no in the family.

    I know I can use excel array function and do aggregation in the family. I have tried incorporating the 'Small' function in the array function to put the Internal_acct_no in ascending order and then concatenating, but it did not work.

    Please see the attached file.
    Attached Files Attached Files

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1