| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I count dates if few duplicates in a column
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I count dates if few duplicates in a column
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I count dates if few duplicates in a column
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I count dates if few duplicates in a column
As long as they are true Excel dates...
=SUM(--(FREQUENCY(C3:C20,C3:C20)0)) -- Biff Microsoft Excel MVP "Tariq Aziz" <Tariq wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count dates in a column | Excel Worksheet Functions | |||
| SUMPRODUCT to count items with duplicates where another column contains two defined items | Excel Worksheet Functions | |||
| Formula to count cells between dates excluding duplicates | Excel Discussion (Misc queries) | |||
| Count cells in a column that contain dates | New Users to Excel | |||
| Count number of unique items in a column that contains duplicates | Excel Worksheet Functions | |||
Hybrid Mode
