MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### How can I count dates if few duplicates in a column

• Follow

```I entered few dates in Column C3 to C20, few of them are duplicates.
How can I count total number of dates (excluding duplicates), duplicates
should be count 1.
```
 0

```Try the below

=SUMPRODUCT(--(C3:C20<>""),1/COUNTIF(C3:C20,C3:C20&""))

--
Jacob (MVP - Excel)

"Tariq Aziz" wrote:

> I entered few dates in Column C3 to C20, few of them are duplicates.
> How can I count total number of dates (excluding duplicates), duplicates
> should be count 1.
```
 0

```Hi,

Try this

=SUMPRODUCT((C3:C20<>"")/COUNTIF(C3:C20,C3:C20&""))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

"Tariq Aziz" wrote:

> I entered few dates in Column C3 to C20, few of them are duplicates.
> How can I count total number of dates (excluding duplicates), duplicates
> should be count 1.
```
 0

```As long as they are true Excel dates...

=SUM(--(FREQUENCY(C3:C20,C3:C20)>0))

--
Biff
Microsoft Excel MVP

"Tariq Aziz" <Tariq Aziz@discussions.microsoft.com> wrote in message
news:2D5CD894-1809-4DB7-A86D-9EBDBAF4B9FC@microsoft.com...
>I entered few dates in Column C3 to C20, few of them are duplicates.
> How can I count total number of dates (excluding duplicates), duplicates
> should be count 1.

```
 0

3 Replies
334 Views

Similiar Articles:

7/11/2012 4:44:53 PM