Close

Page 4 of 4 FirstFirst ... 234
Results 76 to 88 of 88
  1. #76
    Veteran yeah_nah's Avatar
    Join Date
    Oct 2014
    Location
    Perth
    Teams
    Toasters
    Posts
    9,866
    Rep Level
    22971
    Rep Power
    628
    Learn pivot tables my friend (they arent complicated)
    Quote Originally Posted by Eagle E View Post
    I then started saving extra money as a result of eating dumpster food.

    I knew when to hit the dumpster for optimum catch.
    Quote Originally Posted by Eagle E View Post
    accualy scared of getting knocked out by yenny
    #broughtback

  2. #77
    Big Al Baron Samedi's Avatar
    Join Date
    Oct 2014
    Location
    Melbourne
    Teams
    Emanuel Augustus
    Posts
    3,442
    Rep Level
    11893
    Rep Power
    260
    Adelaide Power Los Angeles Lakers
    Quote Originally Posted by Baron Samedi View Post
    anyone here good with excel?

    just want a simple repeating calculation that happens every time the sheet refreshes (eg. pressing F9)

    basically to have a value, say 100, have 1 subtracted from it every time i press refresh so it counts down 99, 98, 97 etc.
    pls halp

  3. #78
    Veteran yeah_nah's Avatar
    Join Date
    Oct 2014
    Location
    Perth
    Teams
    Toasters
    Posts
    9,866
    Rep Level
    22971
    Rep Power
    628
    Quote Originally Posted by Baron Samedi View Post
    pls halp
    Macro by the sounds but don't exactly know wot u mean
    Quote Originally Posted by Eagle E View Post
    I then started saving extra money as a result of eating dumpster food.

    I knew when to hit the dumpster for optimum catch.
    Quote Originally Posted by Eagle E View Post
    accualy scared of getting knocked out by yenny
    #broughtback

  4. #79
    Veteran Triptanes's Avatar
    Join Date
    Oct 2014
    Teams
    Toasters
    Posts
    13,769
    Rep Level
    26354
    Rep Power
    818
    WCE Toast WCE
    ye can only think macro with a button you click to recalc every time

  5. #80
    Veteran Triptanes's Avatar
    Join Date
    Oct 2014
    Teams
    Toasters
    Posts
    13,769
    Rep Level
    26354
    Rep Power
    818
    WCE Toast WCE

    MS Excel Help Thread

    Feel so fucken poverty asking as this should be easy, but Monday morning . Someone help pls

    I have two columns of data. Say one is a name, one is a number. From these two columns I want to make a cell that contains a list of all names that have values below zero. How?

    e.g.
    Column A: A B C D E
    Column B: 5 0 -1 3 -2

    then the function(s) give me the list of -1,-2

    Even just give me a suggestion for something that might make my mind begin to work it out (no pivot tables you pivot table fgts)

  6. #81
    crem de la cra showdownhero's Avatar
    Join Date
    Oct 2014
    Location
    Melbourne
    Teams
    Adelaide, Crystal Palace
    Posts
    10,184
    Rep Level
    19120
    Rep Power
    603
    Adelaide Crows Crystal Palace
    Quote Originally Posted by Triptanes View Post
    Feel so fucken poverty asking as this should be easy, but Monday morning . Someone help pls

    I have two columns of data. Say one is a name, one is a number. From these two columns I want to make a cell that contains a list of all names that have values below zero. How?

    e.g.
    Column A: A B C D E
    Column B: 5 0 -1 3 -2

    then the function(s) give me the list of -1,-2

    Even just give me a suggestion for something that might make my mind begin to work it out (no pivot tables you pivot table fgts)
    have no idea what you're talking about, please screen shot
    Quote Originally Posted by Gamblor View Post
    You're being a massive Clint

  7. #82
    Salty seaman Anchorman's Avatar
    Join Date
    Oct 2014
    Location
    Brickney
    Teams
    Freo Fyfies
    Posts
    1,898
    Rep Level
    10906
    Rep Power
    189
    Fucken nerds
    Quote Originally Posted by Eagle E View Post
    Sex is not a virtuous act unless it is for procreation.

    Consensual sex is an act of mutual exploitation. There is nothing positive to be gained from ejaculation, orgasm and physical sexual interaction. It only causes physiological deterioration.

  8. #83
    crem de la cra showdownhero's Avatar
    Join Date
    Oct 2014
    Location
    Melbourne
    Teams
    Adelaide, Crystal Palace
    Posts
    10,184
    Rep Level
    19120
    Rep Power
    603
    Adelaide Crows Crystal Palace
    Quote Originally Posted by Anchorman View Post
    Fucken nerds
    Quote Originally Posted by Gamblor View Post
    You're being a massive Clint

  9. #84
    #FlyEaglesFly sblack's Avatar
    Join Date
    Oct 2014
    Location
    Sydney
    Teams
    Philadelphia Eagles, Brisbane Lions, Sixers, Hoyas, United, Roma
    Posts
    8,308
    Rep Level
    15172
    Rep Power
    488
    Philadelphia Eagles Man Utd Roma
    Surely just working with =IF function of some sort.

  10. #85
    Veteran yeah_nah's Avatar
    Join Date
    Oct 2014
    Location
    Perth
    Teams
    Toasters
    Posts
    9,866
    Rep Level
    22971
    Rep Power
    628
    Quote Originally Posted by Triptanes View Post
    Feel so fucken poverty asking as this should be easy, but Monday morning . Someone help pls

    I have two columns of data. Say one is a name, one is a number. From these two columns I want to make a cell that contains a list of all names that have values below zero. How?

    e.g.
    Column A: A B C D E
    Column B: 5 0 -1 3 -2

    then the function(s) give me the list of -1,-2

    Even just give me a suggestion for something that might make my mind begin to work it out (no pivot tables you pivot table fgts)
    One cell, with all the names in it? Seems strange m8

    Why not just use a filter?
    Quote Originally Posted by Eagle E View Post
    I then started saving extra money as a result of eating dumpster food.

    I knew when to hit the dumpster for optimum catch.
    Quote Originally Posted by Eagle E View Post
    accualy scared of getting knocked out by yenny
    #broughtback

  11. #86
    Veteran Triptanes's Avatar
    Join Date
    Oct 2014
    Teams
    Toasters
    Posts
    13,769
    Rep Level
    26354
    Rep Power
    818
    WCE Toast WCE
    Quote Originally Posted by showdownhero View Post
    have no idea what you're talking about, please screen shot
    pls respond

    Quote Originally Posted by yeah_nah View Post
    One cell, with all the names in it? Seems strange m8

    Why not just use a filter?
    doing something manually on repeat? pls

    Anyway, all taken care of

  12. #87
    crem de la cra showdownhero's Avatar
    Join Date
    Oct 2014
    Location
    Melbourne
    Teams
    Adelaide, Crystal Palace
    Posts
    10,184
    Rep Level
    19120
    Rep Power
    603
    Adelaide Crows Crystal Palace
    Quote Originally Posted by Triptanes View Post
    pls respond



    doing something manually on repeat? pls

    Anyway, all taken care of
    For column a

    =if(b1<0,a1,"")

    Column b

    =if(b1<0,b1,"")

    Only problem with this is it will leave any positive integer cells blank so you might have to tidy that up with a filter

    Or as Yenny said u could just apply a filter to the original table and that would do the trick
    Last edited by showdownhero; 10th January 2017 at 01:06 AM.
    Quote Originally Posted by Gamblor View Post
    You're being a massive Clint

  13. #88
    crem de la cra showdownhero's Avatar
    Join Date
    Oct 2014
    Location
    Melbourne
    Teams
    Adelaide, Crystal Palace
    Posts
    10,184
    Rep Level
    19120
    Rep Power
    603
    Adelaide Crows Crystal Palace
    just select the cells required and press alt+d then d then f

    this will apply a smart filter to the cells at which point you can remove any cells greater than -1 from being displayed
    Quote Originally Posted by Gamblor View Post
    You're being a massive Clint

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •