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?