| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i count date cells without duplicate values in excel?
In excel sheet I did type dates some date have duplicate values(means repited
same date) including holidays, without some weekdays. Now i want to count that entired dates only without duplicate values. Please help me at the earliest. I am waiting for urs reply. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do i count date cells without duplicate values in excel?
Vasanth,
Should be able to perform a simple countif() function... Any date returning a value of 1 would be unique. Vasanth Kumar wrote: In excel sheet I did type dates some date have duplicate values(means repited same date) including holidays, without some weekdays. Now i want to count that entired dates only without duplicate values. Please help me at the earliest. I am waiting for urs reply. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do i count date cells without duplicate values in excel?
=SUMPRODUCT((A2:A20<"")/COUNTIF(A2:A20,A2:A20&""))
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Vasanth Kumar" <Vasanth wrote in message ... In excel sheet I did type dates some date have duplicate values(means repited same date) including holidays, without some weekdays. Now i want to count that entired dates only without duplicate values. Please help me at the earliest. I am waiting for urs reply. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count once, multiple duplicate values? | Excel Worksheet Functions | |||
| Count Duplicate Values | Excel Discussion (Misc queries) | |||
| How to count duplicate or repeat values | Excel Discussion (Misc queries) | |||
| Count duplicate values in worksheet | Excel Programming | |||
| How do I do count calculations ignoring duplicate values | Excel Discussion (Misc queries) | |||
Hybrid Mode
