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?

You could describe your problem better. An example
would probably help. Maybe the menu Data | Filter |
Advanced Filter | Unique Records Only can get you
started.

Hth,
Merjet

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?
>

Let my try again.....for clarification:

Column A (now)

A
A
A
N
N
N
N
[blank cell] result should be "2" -> keep going
A
A
J
L
F
F
F
[blank cell] result should be "4"-> keep going until you get to the
end of the spreadsheet.

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 <ryguy7...@discussions.microsoft.com>
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 -

On Jan 15, 11:43*am, merjet <mer...@comcast.net> wrote:
> You could describe your problem better. An example
> would probably help. Maybe the menu Data | Filter |
> Advanced Filter | Unique Records Only can get you
> started.
>
> Hth,
> Merjet

A macro that does this:

Let my try again.....for clarification:

Column A (now)


A
A
A
N
N
N
N
[blank cell] result should be "2" -> keep going
A
A
J
L
F
F
F
[blank cell] result should be "4"-> keep going until you get to the
end of the spreadsheet.