In your example you are using two different doctor IDs. Is that a mistake?
Values as displayed
Doctor ID |
Clinic Name |
New Clinic |
Total |
|
Max Clinic Name of the Doctor |
|
70746 |
INTENSIVE CARE UNIT |
INTENSIVE CARE UNIT |
2,177,487.95 |
|
INTENSIVE CARE UNIT |
|
70246 |
NEONATAL INTENSIVE CARE UNIT |
NEONATAL INTENSIVE CARE UNIT |
1,659,829.17 |
|
INTENSIVE CARE UNIT |
|
70746 |
ER Clinic |
ER CLINIC |
1,550,885.53 |
|
INTENSIVE CARE UNIT |
|
A solution in Excel 365 is simpler. Your profile shows Excel 2007 so that is what this solution is for. You must use an array formula:
This is an array formula. After typing in the formula, do not hit ENTER--hit CTRL+SHIFT+ENTER. You have done it correctly if the formula in the formula box has {braces} around it. You cannot type in the braces; they are just an indicator that it is an array formula.
Bookmarks