New Posts For Thread: excel help pleasehttps://community.betfair.com/poker/go/thread/view/94146/23654566/excel-help-pleaseI am trying to achieve the following, count the no. of t's and place the no. in the adjacent cell, resetting after each set of t's when a blank cell is encountered....basically to count the no. of t's between two blank cells...i am just learning excefilter first like Six of Clubs instructed, copy whilst filtered entire column from first occurrencethen turn the filter off and then paste special, values only.https://community.betfair.com/poker/go/thread/view/94146/23654566/excel-help-please?post_id=423933262#423933262filter first like Six of Clubs instructed, copy whilst filtered entire column from first occurrencethen turn the filter off and then paste special, values only.Thu, 31 Dec 2009 00:56:34 -0600Just a thought, you may do well to step out of your work and go play with a few more advanced features. Handling data that size is prone to errors imo. custom views, custom drop downs, tracking and auditing will probly be useful. try and learn shttps://community.betfair.com/poker/go/thread/view/94146/23654566/excel-help-please?post_id=423933254#423933254Just a thought, you may do well to step out of your work and go play with a few more advanced features. Handling data that size is prone to errors imo. custom views, custom drop downs, tracking and auditing will probly be useful. try and learn sWed, 30 Dec 2009 18:27:12 -0600Don't you still have gas lamps in your neck of the woods ;-)https://community.betfair.com/poker/go/thread/view/94146/23654566/excel-help-please?post_id=423933242#423933242Don't you still have gas lamps in your neck of the woods ;-)Wed, 30 Dec 2009 16:19:50 -0600thanks jim will try that...https://community.betfair.com/poker/go/thread/view/94146/23654566/excel-help-please?post_id=423933238#423933238thanks jim will try that...Wed, 30 Dec 2009 16:18:24 -0600There's some clever fkkers on this forum. I have trouble changing a lightbulb :(https://community.betfair.com/poker/go/thread/view/94146/23654566/excel-help-please?post_id=423933234#423933234There's some clever fkkers on this forum. I have trouble changing a lightbulb :(Wed, 30 Dec 2009 15:42:22 -0600lol good luck.cut and paste the data out into a new sheet. sort, then paste back.this may disrupt some forumula though as it sounds like you have data running alongside the list that will be affected. If so, move the list to a different tab and sethttps://community.betfair.com/poker/go/thread/view/94146/23654566/excel-help-please?post_id=423933230#423933230lol good luck.cut and paste the data out into a new sheet. sort, then paste back.this may disrupt some forumula though as it sounds like you have data running alongside the list that will be affected. If so, move the list to a different tab and setWed, 30 Dec 2009 15:41:34 -0600thanks six of clubs..that partially sorts out the problem, but it filters out all the information from the other columns....ideally it would just filter that column...maybe need to do it in another worksheet and link it....yes jim I have this fail sahttps://community.betfair.com/poker/go/thread/view/94146/23654566/excel-help-please?post_id=423933226#423933226thanks six of clubs..that partially sorts out the problem, but it filters out all the information from the other columns....ideally it would just filter that column...maybe need to do it in another worksheet and link it....yes jim I have this fail saWed, 30 Dec 2009 15:35:26 -0600To think this time next year, you will have confirmed that your "super-hunch-cannot-fail-gambling-system" does in fact not work, but you will be able to use excel quite well and can catalogue your CD's whilst reminiscing about the system that almosthttps://community.betfair.com/poker/go/thread/view/94146/23654566/excel-help-please?post_id=423933146#423933146To think this time next year, you will have confirmed that your "super-hunch-cannot-fail-gambling-system" does in fact not work, but you will be able to use excel quite well and can catalogue your CD's whilst reminiscing about the system that almostWed, 30 Dec 2009 10:09:33 -0600click on the column letter with the numbers and blank spaces you want to hide, select data-filter-autofilterthen in the drop down filter that appears scroll to the bottom and select nonblankshttps://community.betfair.com/poker/go/thread/view/94146/23654566/excel-help-please?post_id=423933142#423933142click on the column letter with the numbers and blank spaces you want to hide, select data-filter-autofilterthen in the drop down filter that appears scroll to the bottom and select nonblanksWed, 30 Dec 2009 04:22:57 -0600hi guys....looking for a little more help...is there any way (new problem) I can get rid of the blanks in the column so that it just shows the no.'s in consecutive rowse.g 12372to show as12372any help much appreciatedhttps://community.betfair.com/poker/go/thread/view/94146/23654566/excel-help-please?post_id=423933138#423933138hi guys....looking for a little more help...is there any way (new problem) I can get rid of the blanks in the column so that it just shows the no.'s in consecutive rowse.g 12372to show as12372any help much appreciatedWed, 30 Dec 2009 04:08:17 -0600