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?

Your first example with changes to the range work. Correct result,
however I need to put this in a macro that starts at C1 and loops
through each row and places the calculation that now works on the next
blank cell in that row and continue until the macro is and the end of
the column with no more data........I know this is simple, but I've
had a especially difficult time finding something on this one.

On Jan 15, 11:48*am, ryguy7272
wrote:
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?- Hide quoted text -

- Show quoted text -