I know there is a way to use sumproduct to rank with two columns, and forget
how to make the formula... If not too difficult, I would like to know the
formula to make it descending and ascending...

Example

Name Grade Personal Rank
Dan 98 1
Dan 78 2
Beth 56 2
Beth 67 1