Hi there! So this feels a smidge complicated but I feel like I'm making it more complicated than it needs to be. Here's what I'm trying to do:

I have 10 people who have goals they're supposed to meet. What I'm trying to do is have excel rank them in order of best performer to worst. There are 2 columns of criteria to judge on. Column 1 is simple, it's just whoever has the highest number is first. So someone with a 9 in column 1 is ranked higher than someone with a 4. The 2nd column is inverse, the lower number wins. This one is based on decimals, so someone with .1 ranks higher than someone with .4.

Ultimately what I'm trying to do is have it so Excel will take BOTH columns into account, then rank the people based on the combined rank of both columns, if that makes sense. So someone with an 8 in column 1, .1 in column 2 would rank higher than someone with an 8.2 in column 1, .5 in column 2, if that makes sense.

I wasn't sure if there was a basic formula to get this done or if I needed to cross over into VBA category, so I'm hoping someone can shed some light on this. I'd appreciate the help! Thanks!