Results 1 to 6 of 6

Using Match & Large to rank values.

Threaded View

  1. #1
    Registered User
    Join Date
    03-24-2009
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4

    Using Match & Large to rank values.

    Well, as the title suggests, I'm using a Large function embedded in a Match function to a ranking.

    The issue I'm having is that if there are 2 of the same values in the Top 5, it counts the first one twice rather than each one once. Does anyone have an idea on how to rectify this?

        For H = 1 To 13
            
            For J = 1 To 5
            
             Smile = WorksheetFunction.Match(WorksheetFunction.Large(Range(Cells(11, C), Cells(Botow, C)), J), Range(Cells(11, C), Cells(Botow, C)), 0)
                          
             Margest(M, H, J) = Left(Cells(Smile + 10, "A"), 5)
                          
            Next
            
            C = C + 1
            
        Next
    Thanks!
    Last edited by Kanuhduh; 03-24-2009 at 03:13 PM.

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