In the earlier set-up, #NUM! error lines in cols C and D will appear for any
of the 35 categories with less than 10 players/scores, once all the
player/scores are exhausted in the extract. To suppress this error in-place,
ie make it return "blanks", viz: "" [without using conditional formatting to
mask] ..

Put instead in C2, array-enter the formula, ie press CTRL+SHIFT+ENTER
(instead of just pressing ENTER):
=IF(OR(INDEX(Game,INT((ROW(A1)-1)/10)+1)=0,ISERROR(LARGE(IF(X!$A$2:$A$9000=INDEX(Gam e,INT((ROW(A1)-1)/10)+1),$A$2:$A$9000),MOD(ROW(A1)-1,10)+1))),"",INDEX(X!B$2:B$9000,MATCH(LARGE(IF(X! $A$2:$A$9000=INDEX(Game,INT((ROW(A1)-1)/10)+1),$A$2:$A$9000),MOD(ROW(A1)-1,10)+1),$A$2:$A$9000,0)))
Copy C2 to D2

(Rest of construct unchanged)

Here's a working sample* to illustrate:
http://cjoint.com/?iwixY3UKXm
Auto-List_1st_xx_by_game_in_new_sht_AddErrTrap.xls
*source data in X intentionally amended to contain less than 10 items per
category
(Link is good for 14 days)

If the above event is unlikely, then just stick with the former, shorter
version in cols C and D for optimal calc performance
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---