New Posts For Thread: Spreadsheet help pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/24854593/spreadsheet-help-pleaseI've got an Open Office Calc spreadsheet set out as below A B C D E F G Date Time Course Qualifier ISP Position Runners 11/04/03 1starfish & coffee/Compound MagicMany thanks.https://community.betfair.com/general_betting/go/thread/view/94082/24854593/spreadsheet-help-please?post_id=448864377#448864377starfish & coffee/Compound MagicMany thanks.Sun, 23 May 2010 22:34:55 -0500Excellent! starfish and coffeeMuch simpler than my effort and after reading the problemagain I had an error of making my answer, putting a blank row after every 3 rows of data. Yours is correct after every 4 rows of data.He will have to fill the 4.5,https://community.betfair.com/general_betting/go/thread/view/94082/24854593/spreadsheet-help-please?post_id=448857341#448857341Excellent! starfish and coffeeMuch simpler than my effort and after reading the problemagain I had an error of making my answer, putting a blank row after every 3 rows of data. Yours is correct after every 4 rows of data.He will have to fill the 4.5,Sun, 23 May 2010 21:27:46 -0500another helper column alternative is :-auto fill a column numbered 1 2 3 4 5 6 7 8 9 10 11 12 13 etcat the end of the column autofill it so that it gives 4.5, 8.5, 12.5 etcwhen you sort the column you will have a blank row every 4th rowhttps://community.betfair.com/general_betting/go/thread/view/94082/24854593/spreadsheet-help-please?post_id=448826249#448826249another helper column alternative is :-auto fill a column numbered 1 2 3 4 5 6 7 8 9 10 11 12 13 etcat the end of the column autofill it so that it gives 4.5, 8.5, 12.5 etcwhen you sort the column you will have a blank row every 4th rowSun, 23 May 2010 16:50:25 -0500You could do this ~Using 2 helper columns H and ISelect cell A1:I1 and click data menu, filterIn H1 type 3In H2 next to your first date Paste =IF(H1=3,1,H1+1)and fill down till end of data.In I3 next to your first date Paste =IF(H1=3,I1+1,I1)And fillhttps://community.betfair.com/general_betting/go/thread/view/94082/24854593/spreadsheet-help-please?post_id=448808657#448808657You could do this ~Using 2 helper columns H and ISelect cell A1:I1 and click data menu, filterIn H1 type 3In H2 next to your first date Paste =IF(H1=3,1,H1+1)and fill down till end of data.In I3 next to your first date Paste =IF(H1=3,I1+1,I1)And fillSun, 23 May 2010 14:37:03 -0500shemnelThanks for the advice.To clarify, I would like to insert a blank row after every fourth row of data down to row 1001.Off googling now.https://community.betfair.com/general_betting/go/thread/view/94082/24854593/spreadsheet-help-please?post_id=448790357#448790357shemnelThanks for the advice.To clarify, I would like to insert a blank row after every fourth row of data down to row 1001.Off googling now.Sun, 23 May 2010 12:25:01 -0500google:- insert blank rows at regular intervals excelyou get some help on writing a macro for that sort of thinghttps://community.betfair.com/general_betting/go/thread/view/94082/24854593/spreadsheet-help-please?post_id=448750289#448750289google:- insert blank rows at regular intervals excelyou get some help on writing a macro for that sort of thingSun, 23 May 2010 06:21:36 -0500every 4th row ad infinitum?https://community.betfair.com/general_betting/go/thread/view/94082/24854593/spreadsheet-help-please?post_id=448750053#448750053every 4th row ad infinitum?Sun, 23 May 2010 06:18:19 -0500I've got an Open Office Calc spreadsheet set out as below A B C D E F G Date Time Course Qualifier ISP Position Runners 11/04/03 1https://community.betfair.com/general_betting/go/thread/view/94082/24854593/spreadsheet-help-please?post_id=448740109#448740109I've got an Open Office Calc spreadsheet set out as below A B C D E F G Date Time Course Qualifier ISP Position Runners 11/04/03 1Sun, 23 May 2010 03:37:39 -0500