How do i count date cells without duplicate values in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Vasanth,
Should be able to perform a simple countif() function... Any date
returning a value of 1 would be unique.
 
=SUMPRODUCT((A2:A20<>"")/COUNTIF(A2:A20,A2:A20&""))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Duplicates on two sheets 2
How do I count number of days from a range of dates & some repite. 2
How can I count dates if few duplicates in a column 3
Any experts on the "if statement" desperate insight is needed!!!!!! IF,Count, DCOUNT AHHHGGGGGGG! 7
Counting calculated formulas in a Column 3
Count Function (conditional counts) in Reports 3
Count duplicate values in worksheet 2
Key Card Software (Auric) 7

Back
Top