Results 1 to 19 of 19

Top 3 formula or macro

Threaded View

  1. #1
    Registered User
    Join Date
    12-07-2011
    Location
    Utah
    MS-Off Ver
    Excel 2007
    Posts
    30

    Top 3 formula or macro

    I have a spreadsheet with categories in columns and samples in rows. I need to get the top three categories for each sample. It's quite similar to the question asked in this recent thread asking for the top 5 items, and the answer given there, =INDEX(A:A,MATCH(LARGE(U:U,ROW()-1),U:U,0)), almost works for me with a little modification, except that it fails when there are duplicate values (it returns the first one twice). My values range between 0 and 1, and in many cases, there will be two cells with a value of 1. It seems I need a VBA program or an array function to do this for me, but I only sort of understand how to use array functions and I know virtually nothing about how to use VBA.

    Can anyone help?
    Last edited by drfarmkid; 12-13-2011 at 12:32 AM.

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