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