+ Reply to Thread
Results 1 to 9 of 9

Formula to figure out Top 10 names

Hybrid View

  1. 03-19-2014, 03:22 PM #1
    RobertMika
    RobertMika is offline
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Formula to figure out Top 10 names

    Would this work fir you??
    =INDEX($A$3:$A$28,MATCH(LARGE($C$3:$C$28,ROW(A1)),$C$3:$C$28,0))
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk
    Reply With QuoteRegister To Reply
  2. 03-19-2014, 03:42 PM #2
    cartica
    cartica is offline
    Forum Contributor
    Join Date
    07-21-2013
    Location
    washington dc
    MS-Off Ver
    365 MSO
    Posts
    473

    Re: Formula to figure out Top 10 names

    Rob-

    What does the row() do? It's not $, so if I copy down, I don't understand the significance of it?
    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. [SOLVED] How to insert sub-caption for figures? figure 1, figure 2-a, figure 2-b, figure 3, ...
    By 1tane1 in forum Word Formatting & General
    Replies: 4
    Last Post: 02-03-2014, 08:05 AM
  2. Sum formula to exclude monthly budget figure when actual figure is entered
    By rocketmail in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-02-2013, 04:22 AM
  3. Defined Names and calculation Speed: What's more efficient formula with names or no names
    By JTwrk in forum Excel General
    Replies: 1
    Last Post: 05-14-2012, 10:14 AM
  4. Cross Reference to a Figure actually showing figure, not just caption
    By mgaworecki in forum Word Formatting & General
    Replies: 2
    Last Post: 02-23-2012, 10:53 AM
  5. Calculating monthly sales figure required to make annual turnover figure
    By CatIsoSio Sky in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-27-2010, 04:42 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1