New Posts For Thread: Excel Help!https://community.betfair.com/general_betting/go/thread/view/94082/23512418/excel-helpCan anyone help me with an Excel query....unfortunately i only know the basics and need to know how i would change a column of a couple of hundred figures by dividing those individual figures by the same number....obviously i'd like to divide each fi:)no probs, enjoyhttps://community.betfair.com/general_betting/go/thread/view/94082/23512418/excel-help?post_id=420128882#420128882:)no probs, enjoyThu, 04 Feb 2010 14:53:04 -0600Lori...you're a star...thanks for your help. I owe you one! Cheers!https://community.betfair.com/general_betting/go/thread/view/94082/23512418/excel-help?post_id=420128878#420128878Lori...you're a star...thanks for your help. I owe you one! Cheers!Thu, 04 Feb 2010 14:52:04 -0600in cell d2 type=1980/c2Copy that with ctrl-cHighlight d3 to d99Paste with ctrl-vPress enterhttps://community.betfair.com/general_betting/go/thread/view/94082/23512418/excel-help?post_id=420128874#420128874in cell d2 type=1980/c2Copy that with ctrl-cHighlight d3 to d99Paste with ctrl-vPress enterThu, 04 Feb 2010 14:42:25 -0600thanks for replying ..Lori...i made a mistake....i have a range of cells from c2 to c99...i want the number 1980 to be divided by each cell in the column...any ideas? i appreciate the help. thanks again.https://community.betfair.com/general_betting/go/thread/view/94082/23512418/excel-help?post_id=420128870#420128870thanks for replying ..Lori...i made a mistake....i have a range of cells from c2 to c99...i want the number 1980 to be divided by each cell in the column...any ideas? i appreciate the help. thanks again.Thu, 04 Feb 2010 14:41:16 -0600If you have a column from a1 to a100 and you want to divide by 37type into b1 (or whatever box is to the right of the top your column=a1/37then ctrl-c that (or right click copy), highlight b2 to b100 and paste it.If you wanted to be able to change thhttps://community.betfair.com/general_betting/go/thread/view/94082/23512418/excel-help?post_id=420128862#420128862If you have a column from a1 to a100 and you want to divide by 37type into b1 (or whatever box is to the right of the top your column=a1/37then ctrl-c that (or right click copy), highlight b2 to b100 and paste it.If you wanted to be able to change thThu, 04 Feb 2010 14:27:25 -0600Can anyone help me with an Excel query....unfortunately i only know the basics and need to know how i would change a column of a couple of hundred figures by dividing those individual figures by the same number....obviously i'd like to divide each fihttps://community.betfair.com/general_betting/go/thread/view/94082/23512418/excel-help?post_id=420128858#420128858Can anyone help me with an Excel query....unfortunately i only know the basics and need to know how i would change a column of a couple of hundred figures by dividing those individual figures by the same number....obviously i'd like to divide each fiThu, 04 Feb 2010 13:41:57 -0600