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? |
Count Uniques in Column, put result in next blank cell andcontinu
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 - |
All times are GMT +1. The time now is 03:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com