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
excel-thing-1.png
(33.6 KB, 8 views)
excel-thing-2.png
(35.8 KB, 6 views)
Profile
PM
WWW
Search
BlueCube