- Copy the above formula.
- Replace "CU_Array" with the name of your array.
- Replace "c1:c5" with the range of cells containing the values you want to find the top 3 of.
- Replace "REF" with the reference number of the value you want to find (1 for the largest value, 2 for the second largest, etc.).
I hope this helps! Let me know if you have any further questions.
Formula:
Sub Macro1()
'
' Macro1 Macro
'
'
Range("A1").Select
ActiveCell.FormulaR1C1 = "=INDEX(CU_Array,MATCH(LARGE(c1:c5,REF),c1:c5&ROW(c1:c5)/100000,0),0)"
Range("A2").Select
End Sub