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,626
    Rep Level
    22612
    Rep Power
    616
    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,358
    Rep Level
    11788
    Rep Power
    256
    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,626
    Rep Level
    22612
    Rep Power
    616
    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,605
    Rep Level
    26174
    Rep Power
    810
    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,605
    Rep Level
    26174
    Rep Power
    810
    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
    übermensch showdownhero's Avatar
    Join Date
    Oct 2014
    Location
    Melbourne
    Teams
    Adelaide, Crystal Palace
    Posts
    9,993
    Rep Level
    18931
    Rep Power
    593
    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,852
    Rep Level
    10830
    Rep Power
    187
    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
    übermensch showdownhero's Avatar
    Join Date
    Oct 2014
    Location
    Melbourne
    Teams
    Adelaide, Crystal Palace
    Posts
    9,993
    Rep Level
    18931
    Rep Power
    593
    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,211
    Rep Level
    14964
    Rep Power
    482
    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,626
    Rep Level
    22612
    Rep Power
    616
    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,605
    Rep Level
    26174
    Rep Power
    810
    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
    übermensch showdownhero's Avatar
    Join Date
    Oct 2014
    Location
    Melbourne
    Teams
    Adelaide, Crystal Palace
    Posts
    9,993
    Rep Level
    18931
    Rep Power
    593
    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
    übermensch showdownhero's Avatar
    Join Date
    Oct 2014
    Location
    Melbourne
    Teams
    Adelaide, Crystal Palace
    Posts
    9,993
    Rep Level
    18931
    Rep Power
    593
    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
  •