Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem not counting duplicates
Excel 2003
Ok, I receive info regarding patients in a hospital setting, the pt being identified by Medical Record Number. I need to know the number of pts on a vent in a month, then the compliance to several different tasks on those patients. (# of yes answers divided by the total number of pts) The problem is that a lot of the info is duplicated. I have a formula to disregard the duplicate med rec numbers: =sumproduct((range<"")/countif(range,range&"")) this works fine to count the number of patients for the month without counting duplicates. How can I count the number of yes/no answers in other columns without counting the duplicates? I don't know how to put that together successfully. thanks, Meenie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem not counting duplicates
see your other post
-- Biff Microsoft Excel MVP "Meenie" wrote in message ... Excel 2003 Ok, I receive info regarding patients in a hospital setting, the pt being identified by Medical Record Number. I need to know the number of pts on a vent in a month, then the compliance to several different tasks on those patients. (# of yes answers divided by the total number of pts) The problem is that a lot of the info is duplicated. I have a formula to disregard the duplicate med rec numbers: =sumproduct((range<"")/countif(range,range&"")) this works fine to count the number of patients for the month without counting duplicates. How can I count the number of yes/no answers in other columns without counting the duplicates? I don't know how to put that together successfully. thanks, Meenie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting duplicates | Excel Discussion (Misc queries) | |||
counting duplicates | Excel Discussion (Misc queries) | |||
counting function but not double counting duplicates | Excel Worksheet Functions | |||
Counting duplicates | Excel Discussion (Misc queries) | |||
Counting and duplicates | Excel Discussion (Misc queries) |