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!