+ Reply to Thread
Results 1 to 4 of 4

Doctors Clinic Name based on Maximum revenue

  1. #1
    Registered User
    Join Date
    12-20-2011
    Location
    RIYADH
    MS-Off Ver
    Excel 2007
    Posts
    98

    Red face Doctors Clinic Name based on Maximum revenue

    Hi all,

    Here i have attached an excel sheet with Doctors ID# & Clinic name & Revenue amount , accordingly I need to identify the Clinic name of the Doctors based on the highest revenue performed.
    They worked in multiple clinics but i need to identify the highest revenue clinic name only.


    Thnx
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Doctors Clinic Name based on Maximum revenue

    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:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    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.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    12-20-2011
    Location
    RIYADH
    MS-Off Ver
    Excel 2007
    Posts
    98

    Re: Doctors Clinic Name based on Maximum revenue

    Working excellent .,

    Thanks Bro...

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Doctors Clinic Name based on Maximum revenue

    You're welcome and thanks for the rep!

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Identify the Clinic name based on highest revenue
    By suhabthan in forum Excel General
    Replies: 3
    Last Post: 09-04-2021, 11:50 AM
  2. Need to group patients based on date, clinic, provider, and visit type
    By CapRavOr in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-09-2021, 10:38 PM
  3. Help with clinic patient userform template
    By JNEWMAN in forum Excel Programming / VBA / Macros
    Replies: 57
    Last Post: 09-05-2019, 06:00 PM
  4. [SOLVED] Deferred Revenue, Revenue Recognition --- integrating one time fee!
    By andrew.cloudsnap in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-28-2019, 05:05 PM
  5. Replies: 7
    Last Post: 11-18-2015, 02:33 AM
  6. Revenue Calculation based on Variable revenue Percentage
    By suhabthan in forum Excel General
    Replies: 0
    Last Post: 06-19-2014, 12:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1