On Feb 12, 7:45*am, Mike H wrote:
Hi,

I don't quite understand, what result so you expect to see from the formula?

Mike



" wrote:
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- Hide quoted text -

- Show quoted text -

You can use the RANK function if that is practical for you.
=RANK(B2,$B$2:$B$4)