Counting repeated values

  • Thread starter Thread starter Cath
  • Start date Start date
C

Cath

Hi, I have a column with lots of repeated dates in it and I need t
count how many different dates there are in that column. i.e. ther
could be 15 values of 6/12/04 and 12 values of 3/5/78 and I would nee
to find out that even though there are 27 rows of values there are onl
2 different dates. can anyone help please. Thank
 
Hi Cath
Array formula (Validate with Ctrl + Shift + Enter):
{=SUM(N(FREQUENCY(A1:A10;A1:A10)>0))}

Regards
Pascal
 
Back
Top