We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
Chit Chat
There is currently 1 person viewing this thread.
Can 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 figure in the column by the same number but naturally i would like to do it in a batch....i'd appreciate any help i can get. Cheers!
sort by:
Show
per page
Replies: 7
|
By:
You don't need a spreadsheet
If you divide all the numbers by the same number, they'll all equal 1. Hope this helps |
|
By:
- Your hundreds of numbers are in column A
- The single mumber you wish to divide them all by is in C1 In B1 =A1/$B$1 Then drag that cell down with the thick black square in the bottom right hand corner of the cell. |
|
By:
=A1/$C$1
sorry |
|
By:
You ** the cell by using the F4 button
|
|
By:
Sorry 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.
|
|
By:
Sorry 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 1980 In D2 =C2/$D$1 and drag down. |
|
By:
thanks for your help...i appreciate it.
|