Count number of trips when duplicate entries
Solved/Closed
Keith
-
Apr 13, 2010 at 04:43 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 14, 2010 at 10:21 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 14, 2010 at 10:21 PM
Related:
- Count number of trips when duplicate entries
- Outlook duplicate items remover (odir) - Download - Email
- How to count names in excel - Guide
- Count number of occurrences in excel - Guide
- How to duplicate a google doc - Guide
- How to remove registry entries of uninstalled software - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Apr 14, 2010 at 06:43 AM
Apr 14, 2010 at 06:43 AM
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
upload your sample file in the web
https://authentification.site
remove the password.
give the name of the url in your posting
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Apr 14, 2010 at 10:21 PM
Apr 14, 2010 at 10:21 PM
Keith
rizviza1 has given a solution try that. I do not want to intrude.
rizviza1 has given a solution try that. I do not want to intrude.
Apr 14, 2010 at 10:08 AM
I hope that didn't violate and rules or anything.
I appreciate your help
Thanks Keith
Apr 14, 2010 at 09:41 PM
1. Name the range where the dates of your trip as DATES (in the sample file that would start from cell E29)
2. Name the range where the name of pharmacies are as PHARMA. (in the sample file that would start from cell F29)
3 Once you have done this, go to the list where the names of pharamcies are. Based on your sample file enter the formula given below in cell F13. About formula once you have pasted the formula it is CRITICAL the you DONT not press enter but rather press PRESS CTRL + SHIFT + ENTER AT SAME TIME. If you have done it correctly, you should notice in the formula bar your formula is enclosed in {}. The formula below is based on your sample book
=SUM(IF(FREQUENCY(IF((LEN(DATES & PHARMA) * (PHARMA=E13)) >0,MATCH(DATES & PHARMA,DATES & PHARMA,0),""), IF((LEN(DATES & PHARMA) * (PHARMA=E13)) >0,MATCH(DATES & PHARMA,DATES & PHARMA,0),""))>0,1,0))
In the formula below E13 was the first row in your sample book. Once you have pasted and then have pressed CTRL + SHIFT + ENTER, drag it down to cover rest of pharma
Here is the sample file with the formula and all.
https://authentification.site/files/21949548/Test_File_for_website_help_with_counting_pharmacies.xlsx