How do I count unique records based on two columns in Excel?
Posted on 2014-10-23
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).