+ Reply to Thread
Results 1 to 4 of 4

Get the TOP 20 Agents from list

  1. #1
    Registered User
    Join Date
    08-16-2011
    Location
    ottawa
    MS-Off Ver
    Excel 2010
    Posts
    9

    Get the TOP 20 Agents from list

    hello,

    I need to get the top 20 agents for the list that I have created, attached is the list. I just want that list to be sorted by top agents, basically whos name comes up the most gets sorted from top to bottom.

    Here is the attachment;
    Top Agent Sort.xlsx


    Thanks in advance.

    Ali
    Last edited by allstarleb; 09-24-2012 at 02:54 AM.

  2. #2
    Forum Contributor
    Join Date
    02-22-2011
    Location
    Rhône Alpes, France
    MS-Off Ver
    Excel 2007
    Posts
    201

    Re: Get the TOP 20 Agents from list

    Hi,
    May be a solution using pivot table
    Insert the data as a table
    Insert a pivot table using the table
    Apply a filter to values > Top 10 > View > High - 20 - elements - Number of List Salesperson 1 Name
    You can add or remove data in the table but don't forget to refresh the pivot table
    Hope this help
    Best regards
    Attached Files Attached Files

  3. #3
    Forum Contributor corinereyes's Avatar
    Join Date
    12-02-2003
    Location
    Philippines
    MS-Off Ver
    MS Excel 2016
    Posts
    520

    Re: Get the TOP 20 Agents from list

    Hi,

    You can use the ff. formula;

    On Sheet 1 , cell B2

    Please Login or Register  to view this content.
    and then sorted by Column 2

    You can use the Remove Duplicates (under Data Tab)

    On the sheet named "Final"

    Please Login or Register  to view this content.
    Please find the attached file.
    Attached Files Attached Files
    Corine

  4. #4
    Registered User
    Join Date
    11-27-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Get the TOP 20 Agents from list

    Hi,

    Instead of using so many functions just have a try on Array Summation. This concept is very effective and creative and you can do a lot of stuffs.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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