+ Reply to Thread
Results 1 to 2 of 2

Formula to consolidate and sort descending

  1. #1
    Registered User
    Join Date
    08-02-2016
    Location
    Toronto, Canada
    MS-Off Ver
    Mac 2016
    Posts
    0

    Formula to consolidate and sort descending

    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

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello DSTRUTT,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sort Descending
    By GEMINI528 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-25-2015, 12:53 PM
  2. Sort Descending
    By GEMINI528 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-17-2015, 08:16 PM
  3. [SOLVED] Formula to Sort the Data in Descending Order
    By Ankit_Kumar in forum Excel General
    Replies: 8
    Last Post: 04-27-2015, 07:48 AM
  4. sort Dates in ascending and descending Using formula in excel
    By sabubakaralis in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-02-2015, 10:17 AM
  5. Data sort then sort of same value in descending days of the week
    By jimbob121 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2014, 02:32 PM
  6. Using sort descending in VBA
    By eonizuka in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-05-2010, 06:05 PM
  7. Sort in descending order
    By shahcu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2008, 03:01 AM

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