New Posts For Thread: excel help pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/29238105/excel-help-pleaseI have a spreadsheet with a number of columns. In one of the columns there are a number of values, some of which are the same.There are several thousand rows on the spreadsheet.Is there a function to count how many different values there are in thatStick it in a database (as data should be!) and do:SELECT COUNT(DISTINCT([field])) from [table]https://community.betfair.com/general_betting/go/thread/view/94082/29238105/excel-help-please?post_id=523708037#523708037Stick it in a database (as data should be!) and do:SELECT COUNT(DISTINCT([field])) from [table]Sun, 02 Sep 2012 07:40:44 -0500Mine was old skoolhttps://community.betfair.com/general_betting/go/thread/view/94082/29238105/excel-help-please?post_id=521969481#521969481Mine was old skoolTue, 17 Jul 2012 07:25:45 -0500was it my PM that did it?https://community.betfair.com/general_betting/go/thread/view/94082/29238105/excel-help-please?post_id=521969181#521969181was it my PM that did it?Tue, 17 Jul 2012 07:11:40 -0500Thanks everyonesorted nowhttps://community.betfair.com/general_betting/go/thread/view/94082/29238105/excel-help-please?post_id=521968951#521968951Thanks everyonesorted nowTue, 17 Jul 2012 07:02:16 -0500Easy in AccessImport excel spreadsheet as a tableCreate query, selecting column containing numbers twiceClick on totalsSelect count in second column selectedrun queryCount rowsFor table with a name of sheet1 with the column of numbers headed by numbehttps://community.betfair.com/general_betting/go/thread/view/94082/29238105/excel-help-please?post_id=521968585#521968585Easy in AccessImport excel spreadsheet as a tableCreate query, selecting column containing numbers twiceClick on totalsSelect count in second column selectedrun queryCount rowsFor table with a name of sheet1 with the column of numbers headed by numbeTue, 17 Jul 2012 06:47:14 -0500TryCopy and paste this formula into a spare cell ~=SUBTOTAL(2,AO2:AO10000) ~ that will count the list of unique values placed in column AO by the advanced filterNow for the unique values in the advanced filter ~Lets say all your numbers are in columnhttps://community.betfair.com/general_betting/go/thread/view/94082/29238105/excel-help-please?post_id=521967923#521967923TryCopy and paste this formula into a spare cell ~=SUBTOTAL(2,AO2:AO10000) ~ that will count the list of unique values placed in column AO by the advanced filterNow for the unique values in the advanced filter ~Lets say all your numbers are in columnTue, 17 Jul 2012 06:19:29 -0500It depends how you want your output.Shapeshifters method is fine. I think the one cell formula is:=SUM(IF(FREQUENCY(A2:A1000,A2:A1000)>0,1))You could also consider:1 - Advanced filter: List range is your data range, check copy to another location anhttps://community.betfair.com/general_betting/go/thread/view/94082/29238105/excel-help-please?post_id=521967547#521967547It depends how you want your output.Shapeshifters method is fine. I think the one cell formula is:=SUM(IF(FREQUENCY(A2:A1000,A2:A1000)>0,1))You could also consider:1 - Advanced filter: List range is your data range, check copy to another location anTue, 17 Jul 2012 06:03:07 -0500thanks for your input shapeshifterI've been looking at Help since I posted and I think Advanced filter is supposed to do it but i can't get it to workso I'll try your methodhttps://community.betfair.com/general_betting/go/thread/view/94082/29238105/excel-help-please?post_id=521965647#521965647thanks for your input shapeshifterI've been looking at Help since I posted and I think Advanced filter is supposed to do it but i can't get it to workso I'll try your methodTue, 17 Jul 2012 04:32:39 -0500If no one comes up with a function, you can try this:PUT ALL THE NUMBERS IN COLUMN ALEAVE TOP LINE FOR HEADERSso numbers start at A2in B2, put the following formula=IF(A3=A2,"",A2)Cut and past this down the entire column of BIt will list all the numbhttps://community.betfair.com/general_betting/go/thread/view/94082/29238105/excel-help-please?post_id=521965559#521965559If no one comes up with a function, you can try this:PUT ALL THE NUMBERS IN COLUMN ALEAVE TOP LINE FOR HEADERSso numbers start at A2in B2, put the following formula=IF(A3=A2,"",A2)Cut and past this down the entire column of BIt will list all the numbTue, 17 Jul 2012 04:27:18 -0500I have a spreadsheet with a number of columns. In one of the columns there are a number of values, some of which are the same.There are several thousand rows on the spreadsheet.Is there a function to count how many different values there are in thathttps://community.betfair.com/general_betting/go/thread/view/94082/29238105/excel-help-please?post_id=521965293#521965293I have a spreadsheet with a number of columns. In one of the columns there are a number of values, some of which are the same.There are several thousand rows on the spreadsheet.Is there a function to count how many different values there are in thatTue, 17 Jul 2012 04:08:54 -0500