discharge

I have a large amount of data. I have a scenario where, in column BP (starting at row 6), I need to populate a formula that will look at the claim number in column AS. There will be multiple lines with the same claim number in AS. I need it to compare all the claim numbers that are the same, and...

hi all, just need a tidier way of getting my days allocated to the months in which they fall. my data represents the duration of stay for patients in hospital. I have an admission date and a discharge date (in most cases). I am using the following formula to distribute the total number of days...

Hi, I'm helping a friend improve his patient list (He works for the National Health Service in the UK). He wants a 'view' of his patient list that only shows current patients (i.e. a second sheet with duplicate data, if the patient's discharge date is not set (blank)). The patient lists...

Hi I have a list of hospital patients each with a unique Patient ID, a date of Admission and a date of Discharge. For each readmission I need to indicate if it happened within 30 days their most recent discharge. This is an example of what I am aiming for.... I have managed (in column D) to...

Hello, I have two worksheets in my workbook. The first sheet has a list of patients (all patients have unique identifiers i.e 123456 as their patient number) with all of their office visits listed. The second sheet is the same group of patients with all of their hospital discharge dates listed...