There certainly are ways of getting it done just with formulas, but because of the ranking on duplicate (tie) values, it adds some steps. Especially if you don't have the version of Excel that supports dynamic arrays. Here are some discussions of this:

INDEX MATCH function, avoid duplicate returns - Microsoft Community Hub

Additionally, you don't have, strictly speaking, ranks 1 through 10, but as my example showed, a four-way tie for #6, it makes it more complicated when you get to the top ten.

I don't use INDEX/MATCH a lot so I'm not the best person to walk you further through those steps. Best of luck with your learning!