+ Reply to Thread
Results 1 to 4 of 4

Display Top 10 Results and bring back certain information to populate fields

  1. #1
    Registered User
    Join Date
    01-15-2013
    Location
    Bracknell
    MS-Off Ver
    Excel 2010
    Posts
    86

    Display Top 10 Results and bring back certain information to populate fields

    Good Afternoon,

    Is it possible to bring back a set of data based on the top 10 results of a column? I am trying to avoid using a pivot table if at all possible.

    Issue:
    1. The attached file shows an example extract of a data extract that has thousands of lines. See the “Data” Tab.
    2. I have 3 columns of figures.
    3. I would like to bring back the top 10 results of each of these columns and they all populate different tables.
    4. Therefore Top 10 (highest) time count for column BA, BB and BC
    5. The “Report” tabs should be the output of these columns
    6. Is it possible to only bring back the Top 10 results but also relevant row information? See the Report tabs for the information that I am after.

    This report is forming a part of a larger report and all other formulas are already present so I am hoping to keep the file size quite small. The aim is to then hand this over to someone else to just print on a monthly basis depending on the data that gets added with minimum input.

    Thank you so much,
    Andrew
    Attached Files Attached Files

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Display Top 10 Results and bring back certain information to populate fields

    Hello

    In A2 of report1 try this. Modify the Index part of the formula for the other columns.

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

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    01-15-2013
    Location
    Bracknell
    MS-Off Ver
    Excel 2010
    Posts
    86

    Re: Display Top 10 Results and bring back certain information to populate fields

    Hi Fotis

    You have rescued me - thank you so much. Simple yet brilliant.

    Andrew

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Display Top 10 Results and bring back certain information to populate fields

    You are welcome and thanks for the feedback-your good words & rep!.

+ 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. Enter code into a dropdown list, bring back results
    By thedon_1 in forum Excel General
    Replies: 1
    Last Post: 12-10-2012, 06:10 AM
  2. bring back cell on closed workbook based on 2 sets of information
    By scruffpitt in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-15-2012, 06:19 PM
  3. Replies: 4
    Last Post: 09-04-2012, 03:23 PM
  4. Replies: 6
    Last Post: 01-16-2012, 09:42 AM
  5. Match two cells and bring back the results from a third
    By amyj22x3 in forum Excel General
    Replies: 3
    Last Post: 10-28-2011, 12:50 PM

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