Results 1 to 14 of 14

Labels and values associated with Top-N values in a range

Threaded View

  1. #1
    Registered User
    Join Date
    03-20-2013
    Location
    Amsterdam
    MS-Off Ver
    Excel 2013
    Posts
    12

    Labels and values associated with Top-N values in a range

    In this spreadsheet (worksheet 'Aggregate') I am looking for a way to list the Top-10 from the values from columns like US, U etc. on the right. So for instance in Column N, I'd want the To-10 words from column A that have the highest value in column B (US) listed in declining order with the corresponding actual values from Column B next to them. Could anybody please help me in finding the right formula? Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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