New Posts For Thread: Help with count formula in excelhttps://community.betfair.com/general_betting/go/thread/view/94082/23531650/help-with-count-formula-in-excelCan any1 help with the followingI have a column of number with over a 1000's cells, each cell containing a particular 8 digit number. My problem is I only want to count each digit once, but the digit could appear numerous times in the column.What ischeers for that compound magic!!!https://community.betfair.com/general_betting/go/thread/view/94082/23531650/help-with-count-formula-in-excel?post_id=420810622#420810622cheers for that compound magic!!!Wed, 10 Mar 2010 10:21:29 -0600Just for future reference ~=SUM(IF(FREQUENCY(A2:A10,A2:A10)0,1))the more than symbol did not show in front of the last 0 as typedand should be inserted before the last 0https://community.betfair.com/general_betting/go/thread/view/94082/23531650/help-with-count-formula-in-excel?post_id=420810606#420810606Just for future reference ~=SUM(IF(FREQUENCY(A2:A10,A2:A10)0,1))the more than symbol did not show in front of the last 0 as typedand should be inserted before the last 0Wed, 10 Mar 2010 10:03:40 -0600Triggster 10 Mar 16:35 http://www.brainbell.com/tutorials/ms-office/excel/Count_Only_One_Instance_Of_Each_Entry_In_A_List.htm explains howExcellent site Triggster, never knew it exsisted, going of to study it in depth now. cheershttps://community.betfair.com/general_betting/go/thread/view/94082/23531650/help-with-count-formula-in-excel?post_id=420810586#420810586Triggster 10 Mar 16:35 http://www.brainbell.com/tutorials/ms-office/excel/Count_Only_One_Instance_Of_Each_Entry_In_A_List.htm explains howExcellent site Triggster, never knew it exsisted, going of to study it in depth now. cheersWed, 10 Mar 2010 09:45:55 -0600Thanks very much Bayes that worked perfectly!! Thanks also Ghetto Joe and Compound Magic!!Cheers ladshttps://community.betfair.com/general_betting/go/thread/view/94082/23531650/help-with-count-formula-in-excel?post_id=420810578#420810578Thanks very much Bayes that worked perfectly!! Thanks also Ghetto Joe and Compound Magic!!Cheers ladsWed, 10 Mar 2010 09:45:06 -0600=SUM(IF(FREQUENCY(i10:i1462,i10:i1462),1,0)) should count the number of unique 8 digit numbers.https://community.betfair.com/general_betting/go/thread/view/94082/23531650/help-with-count-formula-in-excel?post_id=420810570#420810570=SUM(IF(FREQUENCY(i10:i1462,i10:i1462),1,0)) should count the number of unique 8 digit numbers.Wed, 10 Mar 2010 09:40:38 -0600The numbers are in cell i10 to i1462.number example = 100142627Many Thanks.I have being trying the formula's you have given and I am getting that circular reference errorhttps://community.betfair.com/general_betting/go/thread/view/94082/23531650/help-with-count-formula-in-excel?post_id=420810566#420810566The numbers are in cell i10 to i1462.number example = 100142627Many Thanks.I have being trying the formula's you have given and I am getting that circular reference errorWed, 10 Mar 2010 09:36:54 -0600http://www.brainbell.com/tutorials/ms-office/excel/Count_Only_One_Instance_Of_Each_Entry_In_A_List.htm explains howhttps://community.betfair.com/general_betting/go/thread/view/94082/23531650/help-with-count-formula-in-excel?post_id=420810562#420810562http://www.brainbell.com/tutorials/ms-office/excel/Count_Only_One_Instance_Of_Each_Entry_In_A_List.htm explains howWed, 10 Mar 2010 09:35:49 -0600If it's just numbers you can use frequency=SUM(IF(FREQUENCY(A:A,A:A)0,1))assuming your values are in column Ahttps://community.betfair.com/general_betting/go/thread/view/94082/23531650/help-with-count-formula-in-excel?post_id=420810554#420810554If it's just numbers you can use frequency=SUM(IF(FREQUENCY(A:A,A:A)0,1))assuming your values are in column AWed, 10 Mar 2010 09:32:30 -0600Try=SUM(IF(FREQUENCY(A2:A10,A2:A10)0,1)) this must be entered as an arraychange the cell references to match where your data ishttps://community.betfair.com/general_betting/go/thread/view/94082/23531650/help-with-count-formula-in-excel?post_id=420810550#420810550Try=SUM(IF(FREQUENCY(A2:A10,A2:A10)0,1)) this must be entered as an arraychange the cell references to match where your data isWed, 10 Mar 2010 09:32:11 -0600Give me an example of the numbers and what exactly you want to count, and I'll have a quick go.https://community.betfair.com/general_betting/go/thread/view/94082/23531650/help-with-count-formula-in-excel?post_id=420810546#420810546Give me an example of the numbers and what exactly you want to count, and I'll have a quick go.Wed, 10 Mar 2010 09:31:11 -0600