Consulting

Results 1 to 10 of 10

Thread: Get Unique days per MD per patient

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Dec 2008
    Posts
    85
    Location

    Get Unique days per MD per patient

    Hi all:

    Enclosed Excel file where I find the unique patients per MD using this array formula (enter has array):

    =SUM(IF(FREQUENCY(IF($B$2:$B$7=$E2,MATCH($A$2:$A$7,$A$2:$A$7,0)),ROW($A$2:$A$7)-ROW($A$2)+1),1))
    Now I am trying to get the unique stay days per patient per MD using this array (which not work - result #value!):

    =SUM(IF(FREQUENCY(IF(AND($A$2:$A$7=$F2,$B$2:$B$7=$E2),MATCH($C$2:$C$7,$C$2:$C$7,0)),ROW($C$2:$C$7)-ROW($C$2)+1),1))
    Please see enclosed Excel 2010 file to see if you can help me to correct this array enter formula.

    Thanks

    Victor
    Attached Files Attached Files

Posting Permissions

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