I am hoping someone on here might be able to assist. I'm having trouble developing a formula to rank, by name, doctors prescribing a certain drug in a wide list of drugs. Essentially, I am trying to identify the top 5 prescribers of a particular item ranked from 1-5 in descending order. Here is what I have:
Column C (Drugs), Column D (Quantity) & Column E (Doctors)
Trying to pull the top 5 prescribers of "*Hydroco/APAP*" from the data and rank them by name without the use of pivot tables and vlookup. Also trying to determine count of that item for each of the 5 and total quantity of that item.
Note: I am pulling data (approx. 40,000 lines) from Sheet1! to another sheet
RAW DATA
Column C Column D Column E
Hydroco/APAP Jim R. 90
Oxcodone Jim R. 90
Abilify Sherry T. 120
Hydroco/APAP Jim R. 120
Hydroco/APAP Pete M. 180
Zolpidem Roger T. 90
Hydroco/APAP Jim R. 120
Hydroco/APAP Melissa F. 30
Adderall Roger T. 30
This is what I want:
Column A Column B Column C
Name 1 Count of Hydroco/APAP Pill Count
Name 2 Count of Hydroco/APAP Pill Count
Name 3 Count of Hydroco/APAP Pill Count
etc.
Need help with pulling name rank, count of item by doc, and pill count of that item for each ranked doc
Hopefully this is possible.
Column C (Drugs), Column D (Quantity) & Column E (Doctors)
Trying to pull the top 5 prescribers of "*Hydroco/APAP*" from the data and rank them by name without the use of pivot tables and vlookup. Also trying to determine count of that item for each of the 5 and total quantity of that item.
Note: I am pulling data (approx. 40,000 lines) from Sheet1! to another sheet
RAW DATA
Column C Column D Column E
Hydroco/APAP Jim R. 90
Oxcodone Jim R. 90
Abilify Sherry T. 120
Hydroco/APAP Jim R. 120
Hydroco/APAP Pete M. 180
Zolpidem Roger T. 90
Hydroco/APAP Jim R. 120
Hydroco/APAP Melissa F. 30
Adderall Roger T. 30
This is what I want:
Column A Column B Column C
Name 1 Count of Hydroco/APAP Pill Count
Name 2 Count of Hydroco/APAP Pill Count
Name 3 Count of Hydroco/APAP Pill Count
etc.
Need help with pulling name rank, count of item by doc, and pill count of that item for each ranked doc
Hopefully this is possible.