I have a list on Sheet2 of the following format:

Name | Rating | Games Played | Wins | Losses | Achievements

The list is alphabetical.

Is there a formula I can use to reorder/rank the names and their associated stats on Sheet1 by RATING. The added trick if possible is I need two lists.. One for people >1000 rating.. and one list for people <1000 (higher rating= higher ranking)?

Thank you for any help.