counting different dates
thanks
"PCLIVE" wrote:
Maybe something like this:
=SUM(IF(FREQUENCY(A1:A7,A1:A7)0,1))
HTH,
Paul
--
"AJ Patel" wrote in message
...
Hi all,
This question may have been answered before but I did not see it going
through many of the posts. Below is what I am looking for
I have a list of returned products column A is the date product is
returned
the other columns data referring to the return. I want to keep a running
total of the # of dates I received returns on. For Example if I have the
following Dates:
8/1/08
8/1/08
8/2/08
8/3/08
8/4/08
8/4/08
8/5/08
I need the running total to say that there are 5 days, basically the
formula
should count each date only once despite having multiple entries on the
same
date.
|