=COUNTA(A1:A50)-SUMPRODUCT((A1:A50<"")/COUNTIF(A1:A50,A1:A50&""))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Repeatdude" wrote in message
...
I need a simple formula to count the total number of repeated text in a
list
(column). Say there is thousands of entries (confirmation numbers) both
numeric, alphabetic and alpha-numeric but many of the entries are repeats.
How can I calculate in one cell the total number of repeated instances in
the
list? And I can't sort the list, just calculate the number of repeated
instances in the list just the way it is, and the list is still growing,
so I
need the formula to be able to count all instances in the list even as
they
are being added. plz help !
|