Solved

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

Posted on 2014-10-23
1
143 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Microsoft Office 2010 is Microsoft's latest edition to their office productivity collection. It "promises to include rich and powerful new ways to deliver your best work". So to start off, I have to say that I'm slightly disappointed... That bei…
To stay competitive, modern businesses must adapt and stay innovative, and this is increasingly only possible by working with outside talent. Managers and executives have understood the power of outsourcing for quite some time, but traditional clien…
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

707 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

13 Experts available now in Live!

Get 1:1 Help Now