Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Weeding out duplicates (Excel 2003)

    I need to do a CountIF formula, and I'm not sure if it's possible. I have a list of patients, and status, for each month of 2005. Ultimately, I want the CountIf to check where status = X and count that patient if the criteria is true. Problem is, since this report is broken down by month, and some patient stays span several months, I'm getting duplicate entries. Is there anyway to weed out duplicate patient entries?

    Thanks - Sat.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Weeding out duplicates (Excel 2003)

    You can use Data | Filter | Advanced Filter to create a list of unique patients, if you don't have one yet, then use a combination of COUNTIF formulas. See attached example.

Posting Permissions

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