Michael Paxton
asked on
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).
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).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.