Thread: Microsoft Excel
View Single Post
 
Reply
Posted 2014-10-06, 11:11 PM in reply to Kazilla's post "Microsoft Excel"
Kazilla said: [Goto]
I know there has to be a way. I have a list of physician's names and all pending orders for that physician. So it looks something like this

face to face | patient | dr somebody| date
face to face | new pa | dr someone | date

So, I have a list of over 400 doctors, how can I tell excel to count and tell me how many times each doctor appears without manually highlighting and counter each individual doctor?


Pivot Table.

Highlight the column you want to make counts of (including the header row such as "DOCTOR"). Go to Insert -> Pivot Table, and just hit OK. On the right side, drag DOCTOR to the "Row Labels" and "Values" section at the bottom right. The Value will automatically switch to "Count of DOCTOR".
Attached Images
File Type: png excel-thing-1.png (33.6 KB, 8 views)
File Type: png excel-thing-2.png (35.8 KB, 6 views)
Old
Profile PM WWW Search
BlueCube enjoys the static noises of ten television sets simultaneously tuned to 412.84 MHzBlueCube enjoys the static noises of ten television sets simultaneously tuned to 412.84 MHz
 
 
BlueCube