|
|
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.
|
|
0
|
|
|
|
Reply
|
 Utf
|
5/25/2010 3:17:01 PM |
|
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
|
|
|
|
Reply
|
Utf
|
5/25/2010 3:26:03 PM
|
|
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
|
|
|
|
Reply
|
Utf
|
5/25/2010 3:28:02 PM
|
|
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
|
|
|
|
Reply
|
T
|
5/25/2010 4:07:21 PM
|
|
|
3 Replies
334 Views
(page loaded in 0.109 seconds)
Similiar Articles: How can I count dates if few duplicates in a column - microsoft ...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 shoul... counting identical items in a column and returning the occurrences ...How can I count dates if few duplicates in a column - microsoft ... counting identical items in a column and returning the occurrences ..... Next by Date: RE: counting ... How to assign unique number to column duplicates? - microsoft ...How can I count dates if few duplicates in a column - microsoft ... How to assign unique number to column duplicates? - microsoft ... How can I count dates if few ... How to count duplicates... - microsoft.public.mac.office.excel ...How can I count dates if few duplicates in a column - microsoft ... I entered few dates in Column C3 to C20, few of them are duplicates. How can I count total number of ... Count but ignore duplicate data - microsoft.public.excel.misc ...You may want to ignore nulls or not. -- KARL DEWEY ... How can I count dates if few duplicates in a column ... Find, hide, or eliminate duplicate data - Access - Office ... Count Consecutive Dates - microsoft.public.accesscounting identical items in a column and returning the occurrences ... How can I count dates if few duplicates in a column - microsoft ... counting ... Count a value excluding duplicates depending on a set criteria ...Counting the number of unique different values in a set ..... values based on 4 criteria ... to a set ... How can I count dates if few duplicates in a ... trying to ... Counting the number of unique different values in a set ...How to assign unique number to column duplicates? - microsoft ..... to assign a unique number to a set ... How can I count dates if few duplicates in a column - microsoft ... COUNTIF is Off by 1 - microsoft.public.excel.miscHow can I count dates if few duplicates in a column - microsoft ... COUNTIF is Off by 1 - microsoft.public.excel.misc How can I count dates if few duplicates in a column ... different color for duplicates!!! how? - microsoft.public.excel ...How can I count dates if few duplicates in a column - microsoft ..... In Two Columns - Hi ..... names of colors, skip duplicates when they are grouped together, but ... How can I count dates if few duplicates in a column - microsoft ...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 shoul... Count occurrences of values or unique values in a data range ...For example, if a column contains: The values 5, 6, 7, and 6, then the ... There are several ways to count unique values among duplicates. What do you want to do? Excel - Using A Formula To Count Duplicates In Two Columns - Hi ...... names of colors, skip duplicates when they are grouped together, but count a duplicate if it shows up later in the column. ... different things for a few days now and can't ... Use formulas to find multi-column duplicates in Excel | TechRepublicDuplicates in the same column are easy to find by sorting or ... contains a column of dates and a column of initials. A few dates ... I’m a duplicate!”; when the count ... Excel - Count But Not Duplicates - Is there a way to count ...Count But Not Duplicates - Is there a way to count a column of text but count... ... been searching and trying different things for a few days now and can't ... 7/11/2012 4:44:53 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
66 followers. 