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

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

I apologize, I want the personal rank to be as shown.... That is the sum
product formula. So Dan's highest percentage is 98 and next highest is 78,
but if ther would be more, it would continue.

"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

Not the answer that you are looking for but would sorting first by Name and
then by grade give you the result that you are looking for?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


" wrote
in message ...
I apologize, I want the personal rank to be as shown.... That is the sum
product formula. So Dan's highest percentage is 98 and next highest is
78,
but if ther would be more, it would continue.

"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

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)