Audrey

You need to hold the first column in your Countif

+COUNTIF($B$14:B$14,B14)-1


--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Audrey Ng" wrote in message
...
Ok, I understand how unique ranking a column works but what if I wanted
to unique rank by row

This is what I have:
Dr. A Dr. B Dr. C Dr. D

Proc. A 50 50 60 60
Proc. B 40 80 70 40


I want:

Dr. A Dr. B Dr. C Dr. D

Proc. A 3 4 1 2
Proc. B 3 1 2 4

I have tried the =RANK(B14,B$14:G$14)+COUNTIF(B$14:B14,B14)-1 formula
but that does not work......

Please help.







*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!