Count Uniques in Column, put result in next blank cell and continu
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?
|