Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Frequency of occurence
Hi folks I asked this recently and was told to use Pivot tables....a good
idea but it didn't work. My problem is this:- I have a number of patients (say 5000 or so) and numbered 1-5000. They come to my clinic several times a year for various things. I want to calculate how often they come for triage, how often for a consultation and who my top users are. I do not want to use a countif function as I do not want to add 5000 patients as countif's. Any suggestions? Many thanks, Danny |
#2
|
|||
|
|||
I would use the Data Filter AutoFilter, and/or the Data Subtotals
features......... Vaya con Dios, Chuck, CBGx3 "Danny J" wrote in message ... Hi folks I asked this recently and was told to use Pivot tables....a good idea but it didn't work. My problem is this:- I have a number of patients (say 5000 or so) and numbered 1-5000. They come to my clinic several times a year for various things. I want to calculate how often they come for triage, how often for a consultation and who my top users are. I do not want to use a countif function as I do not want to add 5000 patients as countif's. Any suggestions? Many thanks, Danny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a Histogram for relative frequency distributions? | Excel Discussion (Misc queries) | |||
Frequency for Histograms in Excel | Charts and Charting in Excel | |||
Determine Frequency in Filtered List | Excel Worksheet Functions | |||
Cumulative Frequency | Charts and Charting in Excel |