How to count filtered criteria that is duplicated only once in excel

[taylorann89]

Help!

I need to count how many visits multiple patients had in one month (3/1/14 -3/31/14). However, some dates are duplicated due to other criteria that is filtered and not shown. I only need to count one date (ex. 3/20/14) one time for EACH patient.

Can someone please tell me what formula(s) I need to use?



[TABLE="width: 284"]
<colgroup><col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3840;"> <col width="98" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584;"> <col width="175" style="width: 131pt; mso-width-source: userset; mso-width-alt: 6400;"> <tbody>[TR]
[TD="width: 105, bgcolor: yellow"]Last Name[/TD]
[TD="width: 98, bgcolor: yellow"]First Name[/TD]
[TD="width: 175, bgcolor: yellow"]Visit Date[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]DOE
[/TD]
[TD="bgcolor: transparent"]JANE
[/TD]
[TD="bgcolor: transparent"]3/11/2014
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]DOE
[/TD]
[TD="bgcolor: transparent"]JANE
[/TD]
[TD="bgcolor: transparent"]3/11/2014
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]DOE
[/TD]
[TD="bgcolor: transparent"]JANE
[/TD]
[TD="bgcolor: transparent"]3/14/2014
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]DOE
[/TD]
[TD="bgcolor: transparent"]JANE
[/TD]
[TD="bgcolor: transparent"]3/20/2014
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]DOE
[/TD]
[TD="bgcolor: transparent"]JANE
[/TD]
[TD="bgcolor: transparent"]3/26/2014
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]DOE
[/TD]
[TD="bgcolor: transparent"]JANE
[/TD]
[TD="bgcolor: transparent"]3/28/2014[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH
[/TD]
[TD="bgcolor: transparent"]JOHN
[/TD]
[TD="bgcolor: transparent"]3/5/2014
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH
[/TD]
[TD="bgcolor: transparent"]JOHN
[/TD]
[TD="bgcolor: transparent"]3/7/2014
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH
[/TD]
[TD="bgcolor: transparent"]JOHN
[/TD]
[TD="bgcolor: transparent"]3/10/2014
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH
[/TD]
[TD="bgcolor: transparent"]JOHN
[/TD]
[TD="bgcolor: transparent"]3/12/2014
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH
[/TD]
[TD="bgcolor: transparent"]JOHN
[/TD]
[TD="bgcolor: transparent"]3/14/2014[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH
[/TD]
[TD="bgcolor: transparent"]JOHN
[/TD]
[TD="bgcolor: transparent"]3/20/2014[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH
[/TD]
[TD="bgcolor: transparent"]JOHN
[/TD]
[TD="bgcolor: transparent"]3/21/2014[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH
[/TD]
[TD="bgcolor: transparent"]JOHN
[/TD]
[TD="bgcolor: transparent"]3/27/2014[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH
[/TD]
[TD="bgcolor: transparent"]JOHN
[/TD]
[TD="bgcolor: transparent"]3/28/2014
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH
[/TD]
[TD="bgcolor: transparent"]JOHN
[/TD]
[TD="bgcolor: transparent"]3/31/2014[/TD]
[/TR]
</tbody>[/TABLE]

 

[Papi]

Welcome to MrExcel.

What version of Excel are you using?

 

[taylorann89]

Welcome to MrExcel.

What version of Excel are you using?

I'm using Excel 2010 version

 

[chetanmehra1989]

Range("A1:B11").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("H4"), Unique:=True