+ Reply to Thread
Results 1 to 2 of 2

A leaderboard but with multiple entries

  1. #1
    Registered User
    Join Date
    08-14-2015
    Location
    London
    MS-Off Ver
    2011
    Posts
    9

    A leaderboard but with multiple entries

    I need a top three that automatically updates when more entries are added on.

    I've searched through array, countif, index, match, mode and max, im just unable to get it to work.

    i think its the lack of numbers that's confusing me.

    attached a spreadsheet
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    11,538

    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.

+ 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. 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