Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with pivot tables
when we determine the last hemoglobin of the month on a group of
patients, then we run a pivot table to determine the distribution of these hemoglobins. Each person should have one hemoglobin, but regardless of what identifier we use, MRN, name, etc, invariably there are a few duplicates in the list. If we count, it doesn't give us the value of the hemoglobin, there's just a "1", or "2". If we use sum, the 2s are added and are falsely elevated (8.8+9.0= 17.8), if we average, the 1s don't show the actual value. Is there another way to get these values accurately, either by Pivot Table or some other way? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with pivot tables
hi,
have you tried to use MIN or MAX? -- isabelle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot tables problem | Excel Discussion (Misc queries) | |||
Localisation problem with pivot tables | Setting up and Configuration of Excel | |||
Pivot tables, stupid problem | Excel Discussion (Misc queries) | |||
Please help: Pivot Tables problem | Excel Discussion (Misc queries) | |||
Problem with times in pivot tables and graphs | Excel Discussion (Misc queries) |