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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1