Hi,
I have a list of (A) Names with duplicates - and (B) Values, I want a formula(s) that will work the same as Consolidate the values for each Name. And then Sort them by Descending value.
The "Consolidated, Sorted-Descending" data would appear in Columns (C) (D) (See below)
I know it would be simple to consolidate data and sort descending but we are trying to automate that function within the table.
(A)Name (B)Sum (C)Name Consolidated (D)Totals
Bob 2 Frank 24
Frank 12 Joe 23
Jim 5 Bob 14
Dave 10 Dave 10
Joe 22 Jim 5
Bob 7
Joe 1
Frank 12
Bob 5
Thanks in advance
Bookmarks