Count Repeat Names
I have a spreadsheet with a list of names that missed an appointment throughout a time period. 'Column B' is the names. I want 'Column D' to show the number of times the patient missed an appointment. Does some know the easiest way to do this? I would like for it to ignore the space after the comma between last, first name in case someone accidentally forgets to add the space if possible.
I attached a template of what I need.
Thanks for any help in the right direction
Last edited by jaytaylor; 01-30-2010 at 02:41 AM. Reason: asked another question about the formula
Hi jaytaylor,
Welcome to the forum.
Based on your sample workbook, enter (or copy and paste) the following formula into cell D3 and copy down to cell D36:
HTH
Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
For dealing with names that lack a space, you can use =SUMPRODUCT(--(SUBSTITUTE(B$3:B$36," ","")=SUBSTITUTE(B3," ","")))
I added the formula and created more balnk rows to add to. How do I just get it to add a zero to the blank rows (instead of the number 6) in my example attached?
Last edited by jaytaylor; 01-27-2010 at 08:01 PM. Reason: Another question on this formula
That would leave it blank.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks