Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Filter duplicates by multiple criteria
Hello Everyone,
Using Excel 2003. I don't use excel often but have gone through a few classes so I kind of have an idea what is possible but not a clue how to do what I want. My data is a list of patients sent from an access database with a list of patients on ventilator therapy. My first goal is to show only the unique records but uniqness is based on a couple of things. My duplicates come when a patient has been moved from room to room. I need to keep only the record that is the last location when the patient was on the ventilator. I have been doing this maually but would like to do it with a filter if it's possible. This is how I figure it out which records to delete. I sort by Admit number, then by ThpyStartDtTm, then by ThpyEndDtTm. If there are duplicate records and the Start Date and End Dates are the same I have to delete all but one record. If the start dates and end dates are a different time frame, I keep both records because this is 2 seperate vent cases. The way I determine which record/records to delete is to look at the PtLocEndDtTm (Patient location). I need to keep the record for the last location the patient was on this therapy and delete the others. Below is an example of a record I need to filter and delete the 2 duplicates. Fields are Pt Number, Pt. Location, PtLocEndDtTm, ThpyType, ThpyStDtTm, ThpyEndDtTm. 1234 4BW 01/08/09 14:00 Vent 01/04/09 18:35 01/06/09 08:30 1234 ICU 01/04/09 18:30 Vent 01/04/09 18:35 01/06/09 08:30 1234 NSI 01/06/09 10:00 Vent 01/04/09 18:35 01/06/09 08:30 In this case I would delete record 1 and 2 because the vent ended when the patient was in NSI. Hope this can be done and I can do it because it will save me about 3 hours a month of manual filtering. Thanks, Linda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to count based on multiple criteria fields w/duplicates | Excel Worksheet Functions | |||
Filter Multiple Columns on Multiple Criteria and count the last co | Excel Worksheet Functions | |||
Best Way for Multiple Criteria to Show From a Filter | Excel Discussion (Misc queries) | |||
Find duplicates in data with multiple criteria | Excel Discussion (Misc queries) | |||
Create macro to filter on multiple criteria | Excel Worksheet Functions |