Count Uniques in Column, put result in next blank cell and continueuntil last row

[S Himmelrich]

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?

 

[merjet]

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

 

[ryguy7272]

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

 

[S Himmelrich]

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.

 

[S Himmelrich]

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.

 

[S Himmelrich]

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.