All Categories› Poker Chat

You need to be logged in to your Sky Poker account above to post discussions and comments.

You might need to refresh your page afterwards.

Excel Help...

SlipwaterSlipwater Member Posts: 3,660
edited February 2015 in Poker Chat

It’s no great secret that where Microsoft packages are concerned, Word is my bag whereas Excel frustrates me (ironic because I work in the financial industry and I have to use the latter every day).

 

Is there a way I can overtype 17* into a cell containing the number 10, hit enter/return, and have the value in the cell change to 27? I know that I can have a separate column which can do the addition for me, but can I eliminate that and simply do the sum in the one cell? I’m not sure if I’m explaining what I mean… another sad irony, because I’m a writer! ;)

 

Google has not been my friend on this matter.

 

 

*numbers used are for example purposes only.

· Share on Twitter
«13

Comments

  • aussie09aussie09 Member Posts: 8,033
    edited January 2015


    there is a short answer and a long answer...





    · Share on Twitter
  • aussie09aussie09 Member Posts: 8,033
    edited January 2015


    the short answer is, "no."






     
    · Share on Twitter
  • aussie09aussie09 Member Posts: 8,033
    edited January 2015


    the long answer is, "nooooooooooooooooooo."





     
    · Share on Twitter
  • SlipwaterSlipwater Member Posts: 3,660
    edited January 2015
    Both of those answers suck.
    · Share on Twitter
  • Phantom66Phantom66 Member Posts: 5,542
    edited January 2015
    What problem are you trying to solve this way?

    Always better to have the original number and the additional number available separately for auditing purposes/error checking even if you do only want to display the running total.
    · Share on Twitter
  • VespaPXVespaPX Member Posts: 12,485
    edited January 2015
    Sounds like a 2 sheet solution.

    1 sheet with individual scores with a 2nd sheet that auto totals them up.
    · Share on Twitter
  • aussie09aussie09 Member Posts: 8,033
    edited January 2015

    the best way to achieve this is to use two cells.  cell a1 is the new number cell a2 is the running total.  then you can copy paste special a1 and add values to a2. 

    to make things easier you can use a button and assign a macro for this action.



    · Share on Twitter
  • bartonironbartoniron Member Posts: 53
    edited January 2015
    I thought this was POKER CHAT!!!!!!!!!!!
    · Share on Twitter
  • VespaPXVespaPX Member Posts: 12,485
    edited January 2015
    In Response to Re: Excel Help...:
    I thought this was POKER CHAT!!!!!!!!!!!
    Posted by bartoniron
    Thanks for your valuable contribution !!!!!!!!!!!!!!!!!!!!!!!!!

    If you're not aware Slip did an excellent Main/Mini Learderboard last year and probably wants to simplify it for this year.
    So it is about Poker
    · Share on Twitter
  • SlipwaterSlipwater Member Posts: 3,660
    edited January 2015
    In Response to Re: Excel Help...:
    In Response to Re: Excel Help... : Thanks for your valuable contribution !!!!!!!!!!!!!!!!!!!!!!!!! If you're not aware Slip did an excellent Main/Mini Learderboard last year and probably wants to simplify it for this year. So it is about Poker
    Posted by VespaPX
    Thanks, Mick.

    And yeah.
    · Share on Twitter
  • bartonironbartoniron Member Posts: 53
    edited January 2015
    So you are his official mouthpiece are you? Is he not capable of speaking for himself ? Saying it is about poker when you have no evidence is an interesting concept. especially when you use the word probably in such an authoratative manner. 
    · Share on Twitter
  • SlipwaterSlipwater Member Posts: 3,660
    edited January 2015
    In Response to Re: Excel Help...:
    So you are his official mouthpiece are you? Is he not capable of speaking for himself ? Saying it is about poker when you have no evidence is an interesting concept. especially when you use the word probably in such an authoratative manner. 
    Posted by bartoniron
    What's the issue? He's correct, as it happens.
    · Share on Twitter
  • VespaPXVespaPX Member Posts: 12,485
    edited January 2015
    In Response to Re: Excel Help...:
    So you are his official mouthpiece are you? Is he not capable of speaking for himself ? Saying it is about poker when you have no evidence is an interesting concept. especially when you use the word probably in such an authoratative manner. 
    Posted by bartoniron
    Can you help or not?
    · Share on Twitter
  • Phantom66Phantom66 Member Posts: 5,542
    edited January 2015
    Might be educating grandmother on the art of dentureless ovum consumption, but...

    do you know you can sum through sheets, if Sheet1 is the front running total sheet and say for example sheets2-366 were daily results.

    Cells in Sheet1 , e.g. c3 could be  =SUM(Sheet2:Sheet366!c3)

    a) you probably knew that
    b) probably doesn't solve your problem

    at least it might help someone on this new Excel worktips thread
    · Share on Twitter
  • F_IvanovicF_Ivanovic Member Posts: 2,412
    edited January 2015
    In Response to Re: Excel Help...:
    I thought this was POKER CHAT!!!!!!!!!!!
    Posted by bartoniron
    33 posts in total and this is your contribution. Brilliant!
    · Share on Twitter
  • SlipwaterSlipwater Member Posts: 3,660
    edited January 2015
    In Response to Re: Excel Help...:
    Might be educating grandmother on the art of dentureless ovum consumption, but... do you know you can sum through sheets, if Sheet1 is the front running total sheet and say for example sheets2-366 were daily results. Cells in Sheet1 , e.g. c3 could be  =SUM(Sheet2:Sheet366!c3) a) you probably knew that b) probably doesn't solve your problem at least it might help someone on this new Excel worktips thread
    Posted by Phantom66
    I actually didn't know that, but I tried it and it does work.

    Is there a way I can add a daily tab and Excel would be able to pull the points across to the running one, including new names etc?
    · Share on Twitter
  • POKERTREVPOKERTREV Member Posts: 9,607
    edited January 2015
    Hi Slippy.

    If I understand you correctly, then the easiest way is......

    Click on the cell with "10" in it & type =10+17 then hit the "Enter" button, the cell then becomes 27.

    Any good?

    It becomes slightly more complicated though if you already have a formula in that cell.

    Usually I would use a column/cell for each number as below......

    If Cell A1 value is 10 & Cell B1 value is 17 we can add our formula so cell C1 shows the total using the formula below.

    Highlight Column C then type =A1+B1 and ENTER......
    if cell A1 =10 & cell B1 =17 Cell C1 will now show the total as 27.

    · Share on Twitter
  • gerardirlgerardirl Member Posts: 1,299
    edited January 2015
    Maybe your question has been already answered (as im too lazy to read the replies).

    Not 100% clear on your query but maybe this might help or maybe I misunderstood your question.

    Place 10 in cell A1

    Place the value you want to add it to in cell a2 (in this case 17)
    Place the formula =a2+$a$1 in cell b2  
    change the value (ie 17) in each row in column A ....so 17 can become 18 in cell a3 and 18 in cell a4
    Double click on bottom right corner of cell b2 to pull the formula down.


    Your question really depends on what cell value remains constant (ie is it the 10 or the 17)

    Hopefully this is useful!


    · Share on Twitter
  • gerardirlgerardirl Member Posts: 1,299
    edited January 2015
    Ah probably no good what I posted as Ive read more.

    So are you saying you will have a list of names and pts and this list of names will change each week with additional pts.
    So week 1 results, week 2 results, week 3 results etc and you  just want to enter week 4 results on 1 tab and automically another tab will update displaying the totals and placing them in the correct order?

    Ger
    · Share on Twitter
  • SlipwaterSlipwater Member Posts: 3,660
    edited January 2015
    In Response to Re: Excel Help...:
    Ah probably no good what I posted as Ive read more. So are you saying you will have a list of names and pts and this list of names will change each week with additional pts. So week 1 results, week 2 results, week 3 results etc and you  just want to enter week 4 results on 1 tab and automically another tab will update displaying the totals and placing them in the correct order? Ger
    Posted by gerardirl
    That would be perfect, but I am not sure it's entirely possible.
    · Share on Twitter
Sign In or Register to comment.