+ Reply to Thread
Results 1 to 7 of 7

Excel Top 10 Dashboard

  1. 12-14-2020, 01:53 PM #1
    Bliznaca
    Bliznaca is offline
    Registered User
    Join Date
    12-14-2020
    Location
    Milan, Italy
    MS-Off Ver
    Microsoft 365
    Posts
    29

    Lightbulb Excel Top 10 Dashboard

    Hi All,

    I need help with creating a dashboard with the top 10 highest values.

    In detail, I have a table with lots of devices that are under service. In this table, I have a column called "Days in Service", this value I have from today`s date minus the open date of the "ticket" (when I receive the device).
    My idea is to create in a separate sheet a dashboard in which I can automatically display the top 10 devices that are in service for more than n days.

    If somebody can help I`ll be very grateful.

    Thank you
    Last edited by Bliznaca; 12-16-2020 at 08:45 AM.
    Reply With QuoteRegister To Reply
  2. 12-14-2020, 01:57 PM #2
    torachan
    torachan is offline
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,302

    Re: Excel Top 10 Dashboard

    Easier with your workbook - see big yellow banner at the head of the page.
    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Reply With QuoteRegister To Reply
  3. 12-15-2020, 04:39 AM #3
    Bliznaca
    Bliznaca is offline
    Registered User
    Join Date
    12-14-2020
    Location
    Milan, Italy
    MS-Off Ver
    Microsoft 365
    Posts
    29

    Post Re: Excel Top 10 Dashboard

    Hello Torachan,

    See the attached file with an example of what`s needed.

    Thank you
    Attached Files Attached Files
    Last edited by AliGW; 12-15-2020 at 04:45 AM. Reason: PLEASE don't quote unnecessarily!
    Reply With QuoteRegister To Reply
  4. 12-15-2020, 10:12 AM #4
    Czeslaw
    Czeslaw is offline
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,287

    Re: Excel Top 10 Dashboard

    Formula
    E2
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    B2
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 12-15-2020, 10:32 AM #5
    davsth
    davsth is offline
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,210

    Re: Excel Top 10 Dashboard

    ot even choose top 10 in the filter options under number. I do not understand the top 10 vs the top 10 with more than n days service (unless in this case the top 10 will only by a number smaller than 10
    Reply With QuoteRegister To Reply
  6. 12-15-2020, 01:07 PM #6
    Bliznaca
    Bliznaca is offline
    Registered User
    Join Date
    12-14-2020
    Location
    Milan, Italy
    MS-Off Ver
    Microsoft 365
    Posts
    29

    Re: Excel Top 10 Dashboard

    Hi Czeslaw,

    I can`t get working the Index formula on the B column in the main database.
    It returns me #NUM!, try to understand the function but need some help here

    Thanks

    Quote Originally Posted by Czeslaw View Post
    Formula
    E2
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    B2
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 12-15-2020, 01:16 PM #7
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Excel Top 10 Dashboard

    There's nothing wrong with the forlulae. I changed them here to the format that is my personal preference and changed the ranges to cover 200 rows. If you need more, change the bits in red

    =INDEX(DATA!A:A,AGGREGATE(15,6,ROW('RESULTS HERE'!$A$2:$A$200)/($E2=DATA!$I$2:$I$200),COUNTIF($E$2:$E2,$E2)))

    and

    =LARGE(DATA!$I$2:$I$200,A2)

    Remember to use ; instead of , since you're in Italy
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dashboard help! Data from columns showing in the correct boxes on dashboard
    By MattExcelLearner in forum Excel Formulas & Functions
    Replies: 35
    Last Post: 06-27-2019, 11:10 AM
  2. [SOLVED] Excel Dashboard
    By Krix in forum Excel General
    Replies: 5
    Last Post: 04-01-2015, 06:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1