I have list of all the prescriptions we got for the year. A new row is created for each medication.
Col A shows the date, Col B shows Pharmacy Name, Column C the medication.
If I pick up more than one medication on a trip to that pharmacy, then my table will show multiple rows with the same date and the same pharmacy names, changing only the medication name in those rows.
I want to count the number of times I went to each pharmacy. A simple count function would work, except if we got multiple medications that day, it may (count) list that pharmacy 3 times (one for each row - remember each row only list one medication) and in Column A it would list the same date 3 times. So when I actually only went their once, it may return an answer of 3, if I just count the column with the pharmacy names. So how can I count the number of times i went to CVS (ie eliminating the duplicate dates listed in column A, for that pharmacy when I picked up more the medication on that trip.. It would be a fucntion maybe that returns a count for that pharmacy name, only if its a unique date that hasn't been counted before. Is that possible?
PS I use Excel 2007 for windows (vista)
to understand better can you post a very small extract of the data and also explain what you want with respect to this sample data base. greetings.
upload your sample file in the web
https://authentification.site remove the password.
give the name of the url in your posting