How To Populate Rank Conditionally?

[xlmaniac]

Dear All,
I do have a small sample data set across A1:D17 as follows:-
Formulae in Column C are created with Sumproduct.
I am looking for formulae in column D, which can yield proposed Rank as shared below.
Pls help with the formula which can deliver the desired result.

Site	Sale	Total Sale	Rank
a	3	50	3
a	4	50	3
b	6	37	4
c	7	27	5
d	9	55	2
e	10	56	1
a	12	50	3
b	13	37	4
a	15	50	3
a	16	50	3
b	18	37	4
c	19	27	5
d	21	55	2
e	22	56	1
e	24	56	1
d	25	55	2

 

[Fluff]

How about
=SUMPRODUCT((C2<=$C$2:$C$17)/COUNTIF($C$2:$C$17,$C$2:$C$17))

 

[xlmaniac]

Thanks a lot Fluff for helping me out again with yet another mesmerising solution.
Really appreciate your support.
Pls accept my sincere gratitude

 

[Fluff]

You're welcome & thanks for the feedback.

 

[xlmaniac]

Dear Fluff,
My data set is spread across almost 5.5 Lakhs rows & when I am dragging this formula, excel is not responding.
Is there any other solution which could be cascaded to this huge data set?
Thanks

 

[Fluff]

What version of Excel are you using?
Please update you account details to show this, as it affects which functions you have.

 

[xlmaniac]

I am using Excel 2010 Version & Windows 7.
Surely, I shall update the info as suggested by you.
Thanks

 

[Fluff]

Ok, in that case I can't think of a "faster" solution.

 

[xlmaniac]

Thanks for your time & support, Fluff.
Really appreciate!!

 

[Fluff]

You're welcome & thanks forthe feedback.

Also thanks for updating your profile