Results 1 to 2 of 2

A leaderboard but with multiple entries

Threaded View

  1. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,953

    Re: A leaderboard but with multiple entries

    This proposal employs a helper column (C) which may be moved and/or hidden for aesthetic purposes.
    The helper column is populated using: =IF(COUNTIFS(A$2:A2,A2,B$2:B2,B2)=1,COUNTIFS(A$2:A$14,A2,B$2:B$14,B2),"")
    Cells F11:H14 are populated using: =IFERROR(INDEX($A$2:$A$14,AGGREGATE(15,6,(ROW($A$2:$A$14)-ROW($A$1))/($C$2:$C$14=AGGREGATE(14,6,$C$2:$C$14/($B$2:$B$14=F$10),ROWS($A$1:$A1)))/($B$2:$B$14=F$10),1)),"")
    Cells F7:H7 are populated using: =F11
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If multiple entries, sum of entries, but in order by date
    By Inventory_Manager in forum Excel General
    Replies: 2
    Last Post: 08-24-2016, 07:34 PM
  2. Replies: 1
    Last Post: 04-05-2016, 11:20 AM
  3. Replies: 14
    Last Post: 09-24-2015, 04:00 PM
  4. [SOLVED] Automatically add multiple original field entries total (that has multiple entries)
    By steverokh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2013, 01:20 AM
  5. Making a leaderboard in excel
    By mmaher5 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-15-2012, 03:17 PM
  6. Replies: 11
    Last Post: 09-19-2012, 08:04 PM
  7. Using VBA: I have a list with multiple entries.Need to reduce down to unique entries
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-25-2011, 03:19 PM

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