Count multiple dates unique to patient

I need to count the number of appointments (DOS Column) that (patient name column or acct # column) occured by patient for the month. Problem is I have no unique or special character to indicate when to start/stop the count. Aside from writing individual formulas, is this possible? I have over 5000 rows of data that I need to combine the charges into a visit. Am I making sense?


For example Jane Doe would return 2 and Harry Brown would return 1.




POS ACCT # PATIENT NAME DOS CPT TX CODE PRI INS
10557 11934 Doe, Jane 9/14/2012 J1561 IGG MC18
10557 11934 Doe, Jane 9/14/2012 96413 NUR MC18
10557 11934 Doe, Jane 9/14/2012 96415 NUR MC18
10557 11934 Doe, Jane 9/28/2012 J1561 IGG MC18
10557 11934 Doe, Jane 9/28/2012 96413 NUR MC18
10557 11934 Doe, Jane 9/28/2012 96415 NUR MC18
10557 13110 Smith, Bob 9/14/2012 J0885 BIO MC18
10557 13110 Smith, Bob 9/14/2012 96372 NUR MC18
10557 13110 Smith, Bob 9/21/2012 J0885 BIO MC18
10557 13110 Smith, Bob 9/21/2012 96372 NUR MC18
10557 13110 Smith, Bob 9/28/2012 J0885 BIO MC18
10557 13110 Smith, Bob 9/28/2012 96372 NUR MC18
10571 15862 Brown, Harry 9/6/2012 Q0138 OTH MC18
10571 15862 Brown, Harry 9/6/2012 96374 NUR MC18
10571 15073 Mister, Mr. 9/11/2012 J9310 CHM MC18
10571 15073 Mister, Mr. 9/11/2012 J2930 STR MC18
10571 15073 Mister, Mr. 9/11/2012 96375 NUR MC18
10571 15073 Mister, Mr. 9/11/2012 96413 NUR MC18
10571 15073 Mister, Mr. 9/11/2012 96415 NUR MC18
10571 15073 Mister, Mr. 9/26/2012 J9310 CHM MC18
10571 15073 Mister, Mr. 9/26/2012 J2930 STR MC18
10571 15073 Mister, Mr. 9/26/2012 96375 NUR MC18
10571 15073 Mister, Mr. 9/26/2012 96413 NUR MC18

Hi ktrobinson,

Here's my version using a pivot table... Sample for forum(1).xlsx

Notice that I added a few columns to your data.

Hopefully it will be pretty straight forward.

Let me know if this will work for you.

Later,
Dennis

Thank you for the quick reply. I followed your steps unfortunately, the formula is returning "0" as the result. Any idea what I am doing wrong?

I must be brain dead or missing something. Can you please look at my attachment and tell me what I am doing wrong? I greatly appreciate your help!

Hi Dennis,

Thanks so much for your help. I appreciate it!

Regards,
Kris