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!
Bookmarks