New Posts For Thread: Anyone Help with Excel Query???https://community.betfair.com/chit_chat/go/thread/view/94038/23465274/anyone-help-with-excel-queryCan 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 fithanks for your help...i appreciate it.https://community.betfair.com/chit_chat/go/thread/view/94038/23465274/anyone-help-with-excel-query?post_id=419082190#419082190thanks for your help...i appreciate it.Thu, 04 Feb 2010 15:24:28 -0600Sorry i got it wrong....i have a column of numbers ranging from c2 to c99...i'd like to multiply those numbers by 1980 and then divide by each cell....thanks for the help....didnt even get a reply on general betting.Divide by each cell?In D1 put 1980https://community.betfair.com/chit_chat/go/thread/view/94038/23465274/anyone-help-with-excel-query?post_id=419081886#419081886Sorry i got it wrong....i have a column of numbers ranging from c2 to c99...i'd like to multiply those numbers by 1980 and then divide by each cell....thanks for the help....didnt even get a reply on general betting.Divide by each cell?In D1 put 1980Thu, 04 Feb 2010 14:54:04 -0600Sorry i got it wrong....i have a column of numbers ranging from c2 to c99...i'd like to multiply those numbers by 1980 and then divide by each cell....thanks for the help....didnt even get a reply on general betting.https://community.betfair.com/chit_chat/go/thread/view/94038/23465274/anyone-help-with-excel-query?post_id=419081398#419081398Sorry i got it wrong....i have a column of numbers ranging from c2 to c99...i'd like to multiply those numbers by 1980 and then divide by each cell....thanks for the help....didnt even get a reply on general betting.Thu, 04 Feb 2010 14:32:10 -0600You ** the cell by using the F4 buttonhttps://community.betfair.com/chit_chat/go/thread/view/94038/23465274/anyone-help-with-excel-query?post_id=419081378#419081378You ** the cell by using the F4 buttonThu, 04 Feb 2010 14:26:40 -0600=A1/$C$1sorryhttps://community.betfair.com/chit_chat/go/thread/view/94038/23465274/anyone-help-with-excel-query?post_id=419081366#419081366=A1/$C$1sorryThu, 04 Feb 2010 14:19:21 -0600- Your hundreds of numbers are in column A- The single mumber you wish to divide them all by is in C1In B1 =A1/$B$1Then drag that cell down with the thick black square in the bottom right hand corner of the cell.https://community.betfair.com/chit_chat/go/thread/view/94038/23465274/anyone-help-with-excel-query?post_id=419081362#419081362- Your hundreds of numbers are in column A- The single mumber you wish to divide them all by is in C1In B1 =A1/$B$1Then drag that cell down with the thick black square in the bottom right hand corner of the cell.Thu, 04 Feb 2010 14:18:53 -0600You don't need a spreadsheetIf you divide all the numbers by the same number, they'll all equal 1.Hope this helpshttps://community.betfair.com/chit_chat/go/thread/view/94038/23465274/anyone-help-with-excel-query?post_id=419081358#419081358You don't need a spreadsheetIf you divide all the numbers by the same number, they'll all equal 1.Hope this helpsThu, 04 Feb 2010 14:18:42 -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/chit_chat/go/thread/view/94038/23465274/anyone-help-with-excel-query?post_id=419081354#419081354Can 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 14:16:05 -0600