MikeMcCollister
Board Regular
- Joined
- May 6, 2020
- Messages
- 75
- Office Version
- 365
- Platform
- Windows
I have a "Regular Table" with names and numbers associated with them. I want to compress that table into the alphabetized unique names with the aggregate values for each name. I can use
to get the sorted array for unique names. However, I don't know how to get the aggregate values for each name so that it creates an array that will grow if my original table grows. Any idea how to do that?
In the screen capture above, I put the formula that I am using in B15 as text in C15 for reference. B16 to B20 use similar formulas.
Thanks,
Mike
Excel Formula:
=SORT(UNIQUE(Table1[Name]))
to get the sorted array for unique names. However, I don't know how to get the aggregate values for each name so that it creates an array that will grow if my original table grows. Any idea how to do that?
In the screen capture above, I put the formula that I am using in B15 as text in C15 for reference. B16 to B20 use similar formulas.
Thanks,
Mike