Solved

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

Posted on 2014-10-23
1
147 Views
Last Modified: 2014-11-07
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).
0
Comment
Question by:paxtonm
1 Comment
 
LVL 15

Accepted Solution

by:
Haris Djulic earned 500 total points
ID: 40400408
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

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VBA Hide Row Based on Cell Color 19 176
excel 2013 substitute function 8 85
why can't I sort this by internment date 1 42
Excel 2010 - Comparison of texts in a cell 14 36
Outline Suppose you have some simple text based data in Excel that you would like to display as a PowerPoint presentation. Of course it would be possible to write some fairly complex VBA code that created a new slide for each line of the Excel data…
In this article I will provide some simple productivity hacks that will help you use Google to specifically show results from any web site (Experts-Exchange.com in my example), with minimal effort in Chrome and Firefox. I've seen a common theme a…
This video teaches the viewer how to align pictures around text while keeping the text properly aligned in the document.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now