Results 1 to 16 of 16

countif column range equals any other cell in same range

Threaded View

  1. #1
    Registered User
    Join Date
    05-02-2010
    Location
    USA
    MS-Off Ver
    Excel 03/07
    Posts
    17

    Question countif column range equals any other cell in same range

    Hi all,

    I'm trying to count the number of re-admissions within a certain time frame (let's say no more than 60 days apart) by sorting data by patient id# then discharge date and counting the number of repeat values in this column that occur within this time frame. I was thinking a COUNTIFS would do the trick but do not know how to tackle the issue of writing a criteria expression for any cell in a cell range equaling any other cell in that same range. Basically I need the number of occasions where an ID# is reoccurs inside the time window.. So an ID# that shows up 9 times but only 4 instances of closely spaced consecutive service would count as 4. Also, a count of unique patient ID#s that fulfill the re-admission criteria would be useful..

    I suppose this is a common manipulation in business terms as "repeat customers"..
    Any help would be much appreciated. Thanks!
    Last edited by pacer31; 06-27-2011 at 05:24 PM.

Thread Information

Users Browsing this Thread

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

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