Zelaron Gaming Forum

Zelaron Gaming Forum (http://zelaron.com/forum/index.php)
-   Tech Help (http://zelaron.com/forum/forumdisplay.php?f=329)
-   -   Microsoft Excel (http://zelaron.com/forum/showthread.php?t=52615)

Kazilla 2014-10-06 12:02 PM

Microsoft Excel
 
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?

BlueCube 2014-10-06 11:11 PM

2 Attachment(s)
Quote:

Originally Posted by Kazilla (Post 703391)
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".

Kazilla 2014-10-07 11:30 AM

ERMERGERD, I swear I was looking at pivot table all day but couldn't figure out where I was supposed to drag the information from. Jeebus, thanks man.

WetWired 2014-10-08 07:53 AM

Or you could just use COUNTIF depending on what your actual goal is.

Kazilla 2014-10-08 09:37 AM

I also looked at COUNTIF but everything I saw said you had to show exactly what you wanted it to count, which would require typing in each individual doctors names, right?

WetWired 2014-10-08 11:47 PM

Yes. Like I said, it depends on what your actual goal is. It is, of course, possible to overcome this limitation, but it seems that the pivot table may work out better.

Skurai 2014-10-09 05:56 AM

Quote:

Originally Posted by BlueCube (Post 703395)
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".

I've been looking for something like this for a long time, so I'm glad this thread happened.

WetWired 2014-10-09 07:56 PM

Of course, TBH, Excel is the wrong tool for the job. With a relational database, you could easily extract this and more...

Kazilla 2014-10-14 08:15 AM

What is that exactly? I know there is a microsoft application that is specifically used for databases. I just cant remember the name.

WetWired 2014-10-14 10:30 PM

MS Access

Kazilla 2014-10-15 01:52 PM

Lemme ask you this. I have about 60 patients I need to track authorization for. Authorization is what the insurance gives us to see a patient (like permission). Each patient is different. Their authorization expires within a 30, 60, 90 day period. I have 5 separate disciplines I am tracking for authorizations. For instance

Joe Somebody has 5 SN visits, 3 PT vists, and 8 OT vists. This auth is good from 10/10/14 to 12/8/14.

I need to be able to create something that is visually pleasing that makes it easy to tell when additional auth is required. Is that something Access would do better than excel?

WetWired 2014-10-16 03:44 PM

Quite possibly. Access lets you create forms to view records (and joined records), rather than viewing a table. You can also create a query that would include the latest (of possibly many) authorizations for a patient.

Access can be a pain if you're trying to tightly control the procedure to enter information, but if you're currently using Excel, then it's an upgrade in terms of functionality easily added and usability.


All times are GMT -6. The time now is 05:36 AM.

Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
This site is best seen with your eyes open.