taylorann89
New Member
- Joined
- Sep 4, 2014
- Messages
- 2
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?
<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>
</tbody>
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?
| Last Name | First Name | Visit Date |
| DOE | JANE | 3/11/2014 |
| DOE | JANE | 3/11/2014 |
| DOE | JANE | 3/14/2014 |
| DOE | JANE | 3/20/2014 |
| DOE | JANE | 3/26/2014 |
| DOE | JANE | 3/28/2014 |
| SMITH | JOHN | 3/5/2014 |
| SMITH | JOHN | 3/7/2014 |
| SMITH | JOHN | 3/10/2014 |
| SMITH | JOHN | 3/12/2014 |
| SMITH | JOHN | 3/14/2014 |
| SMITH | JOHN | 3/20/2014 |
| SMITH | JOHN | 3/21/2014 |
| SMITH | JOHN | 3/27/2014 |
| SMITH | JOHN | 3/28/2014 |
| SMITH | JOHN | 3/31/2014 |
