What you need to make this work is an otherwise-unused row to hold the X-count for each person. If you make that row 1, you can tally the Xs for each person with a formula like:
=COUNTIF(A2:A100,"X")
copied across as far as needed. You can then do a highest-to-lowest, left-to-right sort based on row 1 as the criterion.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]