Hi all!!
I am trying to get the code below this to give me the top 5 values in a column and offset 0, -2 and put the results in a msgbox. The range is y32:y57 for the top 5 and W32:W57 for the value needed. This would include duplicate results of the top 5. Just for testing purposes, my first 10 numbers in Y32:Y41 are 6, 2, 7, 2, 7, 4, 4, 2, 4, 7 respectively. W32:W41 are 6,20,2,24,18,25,11,15,23,14 respectively. Any help would be appreciated. Feel free to point out what I missed or did wrong, still learning.
Please Login or Register to view this content.
Bookmarks