Sumproduct

[dperez6811]

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

 

[Mike H]

Hi,

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

Mike

 

[dperez6811]

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.

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[HKaplan]

Hi,

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

Mike





- Show quoted text -

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