• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Counting Unique Dates

T

T.Ho

New Member
Hello,

I am trying to count the number of unique dates that each of my subjects attended a session. I currently have a person identifier in column A (some of which are listed multiple times) and the dates in column B. I want column C to tell me how many times they attended. I am having trouble applying this number to each subject individually.

I hope that makes sense...

Any help would be appreciated!

THo
 
Hi Faseeh, thanks for the reply. I tried to use the same formula as offered by Sajan, but I am getting an error "this formula contains unrecognized text". Maybe I am just a noob and entered something in that didn't apply in my situation...I'm not sure? I feel like I'm doing something wrong with the clist and slist things? Or maybe the sdates...

I'm sorry I am not very experienced...

Thanks!
 
Hi ,

If you are a beginner in Excel , then it would be better if you upload your workbook ; we can insert the formula and re-upload your file ; you can go through it at your leisure , and see how Sajan's formula has been adapted to your problem.

Narayan
 
Hi All,

Sorry I am coming back to this so late now, but work was very busy! I have created an example of the workbook so that I can see what the formula looks like. The actual information is confidential unfortunately.

As you can see in the spreadsheet, each person (ref #) has multiple admissions of different dates. I want to fill the 3rd column with the total number of admissions (e.g. 1 admission for Ref1, 3 admissions for Ref3, etc.)

Appreciate the help!

THo
 

Attachments

  • Example THo.xls
    7 KB · Views: 6
Hi, T.Ho!
Try this in C2:
=CONTAR.SI(A$2:A$14;A2) -----> in english: =COUNTIF(A$2:A$14,A2)
Copy down as required.
Regards!
 
You must log in or register to reply here.
Back
Top