Count Days in List

A

Andy

What formula can I use to count the number of days that occur in a list of
cells. Some cells will contain the same date two or three times, but I only
want to count that date once. (i.e. 1,2,2,3,3,3 would count as three dates,
not six).
 
P

Peo Sjoblom

One way

=SUM(IF(C1:C100<>"",1/COUNTIF(C1:C100,C1:C100)))

entered with ctrl + shift & enter

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 

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

Top