How do I count unique records based on two columns in Excel?

In Excel 2010,  how do I count unique records based on two columns?

For example, I may have a patient that has the following three presecriptions:

Name          Drug                       Dosage
Smith          Simvastatin           40mg
Smith          Simvastatin           20mg
Smith          Omeproezal          20mg
Jones           Cyclobanzaprine  10mg

This should have a count of three (3)

Secondarily, how could I count all unique Name, Drug, Dosage combinations, which in this example would be four (4).

Lastly, how could I count the number of patients with multiple unique prescriptions, which in this example would be two (2).
Michael PaxtonProcess EngineerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Haris DjulicConnect With a Mentor Commented:
Hello,

attached is the file with examples of the formulas, for some formulas I added new columns to concentrate date so that the formula will be less complicated...
COUNTS.xlsx
0
All Courses

From novice to tech pro — start learning today.