# Count unique text values between dates

#### Superform

##### New Member
Hi,

So I have a list of start dates in 1 column and a list of names in another.

I am currently counting the number of start dates that fall into a range, however I also need to only count them 1 time if there is a text duplicate in another column.

So I have a 2 dates in 2 cells that are my between dates and I have this formula to calculate the number of entries that fall between the 2 dates
=COUNTIFS(B:B, ">="&A1, B:B, "<="&B1 )

A1 and B1 contain the date range

What I need to do is only count 1 x David if the date in the second column falls in the range of my dates.

So the below example would count 3

Date Range 1/1/2016 - 30/1/2016

 David 13/1/2016 David 13/1/2016 David 13/1/2016 Fred 26/2/2016 Fred 26/2/2016 Sam 29/1/2016 Sam 29/1/2016 Sam 29/1/2016 Bill 29/1/2016 Bill 29/1/2016

<tbody>
</tbody>

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

##### MrExcel MVP
Control+shift+enter, not just enter:
Rich (BB code):
=SUM(IF(FREQUENCY(IF(1-(\$A\$2:\$A\$11=""),IF(\$B\$2:\$B\$11>=\$E2,
IF(\$B\$2:\$B\$11<=\$F2,MATCH(\$A\$2:\$A\$11,\$A\$2:\$A\$11,0)))),
ROW(\$A\$2:\$A\$11)-ROW(\$A\$2)+1),1))
where E2 =1/1/2016 and F2 = 30/1/2016.<strike></strike>

Replies
0
Views
63
Replies
1
Views
100
Replies
2
Views
128
Replies
3
Views
101
Replies
2
Views
77

1,147,734
Messages
5,742,861
Members
423,760
Latest member
photogfrog

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back