| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Top Ten List
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Top Ten List
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing List A to List B and add what's missing from List B | Excel Discussion (Misc queries) | |||
| create new list from list A, but with exclusions from a list B | Excel Worksheet Functions | |||
| validation list--list depends on the selection of first list | New Users to Excel | |||
| list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Linear Mode
