I would strongly suggest you store a ranking of sorts on the Paste sheet.
Given you're using XL2007 you can make use of the SUMIFS & COUNTIFS functions in pref. to Arrays given they are significantly more efficient.
With the above in place you can then collate your info on 'By Wm' sheet such that:
by my reckoning the results should be 800, 800, 600, 10 rather than 630,550,800,9 ... your prior Array would only ever return the results for the first first test that met requirements (ie name & code) the scores themselves were never used as any basis for selection (ie MAX was never being accounted for).
The use of SUMIFS will be more efficient than the Array and also removes need for error handler (0 will be result should a combination not exist).
Bookmarks