Easy one:
=SUMPRODUCT((A2:A78<"")/(COUNTIF(A2:A78,A2:A78&"")))

=SUM(IF(FREQUENCY(IF(LEN(A2:A971)0,MATCH(A2:A971, A2:A971,0),""),IF(LEN(A2:A971)0,MATCH(A2:A971,A2: A971,0),""))0,1))
Note: this is entered with Ctrl+Shift+Enter

=COUNT(1/FREQUENCY(A1:A400,A1:A400))

=SUM(--(FREQUENCY(IF(A2:A2677<"",MATCH(A2:A2677,A2:A2677 ,0)),ROW(INDIRECT("1:"&ROWS(A2:A2677))))0))
Note: this is entered with Ctrl+Shift+Enter


Regards,
Ryan--




--
RyGuy


"S Himmelrich" wrote:

The subject seems to be easy, but I'm not finding any helpful code
that provides insight to doing this. Can anyone help me out on this
one?