Multiple Ranking Criteria

I am trying to rank a list of names based off of more than one column. I would like to rank the list of names down column B based on column D AND F. Can this be done?

Thank you!

Do you mean that the ranking should be based on column D with F as tie-break or do you want to rank on the sum of D and F or something else?

My bad, I should have been a little more clear. I do want to rank it based on D and then F as the tie breaker. Sorry about that.

OK assuming that highest is ranked 1 then this should do what you want in row 1 copied down, extend ranges as necessary

=RANK(D1,$D$1:$D$10)+SUMPRODUCT(--($D$1:$D$10=D1),--($F$1:$F$10>F1))

you are awesome!