Mixt
Joined:
Oct 18, 2006
Messages:
2,173
Material Points:
116
Local Time:
1:25 AM
Total Ratings:
797

Post Ratings

Received: Given:
Like 777 397
Dislike 0 0
Rude 0 0
Agree 4 0
Disagree 0 0
Informative 1 0
Useful 8 0
Creative 12 0

Awarded Pins 6

Gender:
Male
Birthday:
Mar 6, 1992 (Age: 25)

Mixt

The dude that does the thing, Male, 25

Premium
    1. Amp
      Amp
      Can you use the Find and Replace feature in Excel to replace text only in a certain column or row? (I'm not seeing anything in the advanced options for Find and Replace.) For example, if I want to apply the color blue to cells that contain the word "blue," I can obviously use the Find and Replace dialogue box to do that. However, if I only want it to be done to, say, row three, how would I do that?
      1. Mixt
        Mixt
        I'm not sure one way or another on that. I've never needed to before and while it seems reasonable I'm not sure how I would actually try to tell the program what I wanted. Although your example falls more in the domain of conditional formatting.
        Apr 17, 2017
        Amp likes this.
      2. Amp
        Amp
        Yeah, that'd work, too, of course. A better example would be wanting to change the text "blue" to "red" only in row three.
        Apr 18, 2017
    2. Amp
      Amp
      About time!
      1. Mixt
        Mixt
        I mean, I'm always happy to teach what I know but time is a very broad and complicated topic.
        Mar 31, 2017
    3. Amp
      Amp
      I recently changed to Outlook 2016. Any idea why you can't use domain names for message rules in Outlook 2016? Using domain names, you can cover an entire domain rather than having to add a rule via an individual email message and hope it covers everything (http://i.imgur.com/o9UHS3L.png), which it doesn't always, or add multiple rules, such as one for verify@example.com, one for notify@example.com...
      1. View previous comments...
      2. Amp
        Amp
        However, that method doesn't seem to work with Outlook 2016, at least not using the "from public or public group" rule, the one that makes the most sense to use.
        Mar 15, 2017
      3. Amp
        Amp
        I mean, I suppose I could use the "with specific words in the sender's address" method, and then I could do what I want. It would get the job done, I guess, but it's still strange.
        Mar 15, 2017
      4. Mixt
        Mixt
        I'm not experienced in outlook, but that should work fine. I can't think of a situation where that would lead to a false positive or anything. Really as far as I can tell the two options even seem to function in the same manner under the hood (find string in address), they were probably just separate in an attempt to make the user think of different use cases.
        Mar 15, 2017
        Amp likes this.
    4. Amp
      Amp
      One thing I like about Excel is that even with the large workbook I have for the activity log, it opens instantly, whereas in OpenOffice Calc, it has to load the document, which takes at least a minute, I think. The only waiting with Excel is the starting logo before the spreadsheet opens, which isn't even a second.
    5. Amp
      Amp
      Why you no have avatar!?
      1. Mixt
        Mixt
        When setting it back from the joke one I wanted to update it to be a higher resolution. But I've been lazy.
        Jan 12, 2017
        Amp likes this.
      2. Amp
        Amp
        Stop being lazy and hop to it! ;)
        Feb 13, 2017
    6. Amp
      Amp
      Can you answer in Technology? You're an expert.
    7. Amp
      Amp
      You're naked.
      1. Mixt
        Mixt
        The breeze feels nice.
        Nov 12, 2016
        Zelda, tamale and Amp like this.
    8. Amp
      Amp
      Yeah, from what I know, discussion is fine, and in this case, I own the games. It's just when it gets to the "how to" part that it becomes a problem, but there can sometimes be gray areas there, so...

      I may give that try if it comes to it, and if I do, I will hit you up on Skype for any additional questions.
    9. Iskandar
      Iskandar
      You see the Kingsglaive film yet?
      1. Mixt
        Mixt
        Not yet. showtime is about 5 hours out still.
        Aug 21, 2016
      2. Iskandar
        Iskandar
        wow, you've got a late showing
        Aug 21, 2016
    10. Iskandar
      Iskandar
      Make sure you stay all the way through the credits when you go see the movie tomorrow. There's a second or two where the screen stays black, but then it plays the credit scene. And those credits are deceptively long. About halfway through it looks like it's going to end when they show all the logos and company names, but then it goes on again. You'll know when it's done because it'll say SQUARE ENIX at the end.
    11. Amp
      Amp
      I use M/D/YYYY (eg, 2/5/2016) for my spreadsheet dates. For some reason when I input 1/2 or 1/4 and press enter, which will automatically add the current year, or type the next slash and the year, it automatically changes to the small 1/2 and 1/4 (as in measurements).

      I could type Jan 2 or 4 as a workaround, but is there any way to not have it do that?
      1. Mixt
        Mixt
        You could go to "Tools > AutoCorrect Options" and remove the conflicts. Or a leading zero will stop it from matching the autocorrect list (such as 01/2)
        Feb 20, 2016
        Amp likes this.
    12. Love
      Love
      *whisper, whisper* Hey Mixt this is the voice at the back of your mind, it's telling you to get on skype !! *whisper, whisper*
    13. Amp
      Amp
      Noooooooooooooooooo...!
      1. View previous comments...
      2. Amp
        Amp
        I can't tell the latter, anyway, since you're being sneaky.
        Apr 28, 2015
      3. Mixt
        Mixt
        Hehehe.

        Don't worry, I left on good terms and I will probably try and get the position back later.
        Apr 28, 2015
      4. Amp
        Amp
        Hectic life right now?
        Apr 28, 2015
    14. Amp
      Amp
      Welp, fun while it lasted! :D
    15. Amp
      Amp
      Don't forget your user title.

      Back to the oldie, eh?
      1. Mixt
        Mixt
        What can I say, souls of the damned are yummy. (I'm due for a replacement, but I lack the inspiration to make a suitable replacement at the moment)
        Jan 17, 2015
    16. Amp
      Amp
      Guess who has to have their CPU replaced again? This guy.

      Fan died God knows how long ago. It's part of the whole unit, though, and someone from another forum thinks that the fan dying and causing the CPU to overheat when doing intensive tasks, like rendering a video, could possibly have damaged it, so the whole thing will need to be replaced again.
      1. View previous comments...
      2. Amp
        Amp
        Thank you. :)

        Already got that done. See the update notes in my Stupid Computer thread.
        Jan 5, 2015
      3. Amp
        Amp
        I'm still in shock. I mean, it would seem like common sense that an hour video would take an hour or more to process due to the length, but I guess not.
        Jan 5, 2015
      4. Amp
        Amp
        Thank you, by the way! Your awesome technical responses when it comes to stuff like this are always appreciated.
        Jan 6, 2015
    17. Amp
      Amp
      Fact: I like you.
      Fact: You're cool.

      And I just realized your username is your real name twisted around like Roxam as well as the Organization XIII members. /lateonrealizing
      1. Amp
        Amp
        Help me brainstorm anagrams for Amaury that sound best, as you put it. :D
        Dec 28, 2014
    18. Amp
      Amp
      Nights and I got everything, except BF5: Honest Opinions.

      We can't figure out what the hint is. Any help, please? T_T
      1. Amp
        Amp
        After spending about an hour, we of course get it figured out... -_- *cries*
        Dec 26, 2014
      2. Mixt
        Mixt
        And now begins what I consider to be the hardest move in the castle, though like all puzzles difficulty will vary by who is solving it.
        Dec 26, 2014
    19. Amp
      Amp
      Who you gonna be for this year's CO event?
      1. Mixt
        Mixt
        Wait and see. Muwahahaha. (I totally didn't procrastinate on picking one. What are you talking about.)
        Dec 24, 2014
      2. Amp
        Amp
        Oh, Mixt... -_-
        Dec 24, 2014
    20. Amp
      Amp
      Fact: Your name is green.
      1. Mixt
        Mixt
        Technically it is only about 67.2% green. Black and white are also present at about 16.4% each (or you could think of it as 32.8% gray).
        Dec 1, 2014
      2. Amp
        Amp
        Heh!
        Dec 1, 2014
  • Loading...
  • Loading...
  • About

    Gender:
    Male
    Birthday:
    Mar 6, 1992 (Age: 25)

    Signature

    There are some friends, some that I hardly know, but we've had some times I wouldn't trade for the world.
    [​IMG]
    [​IMG]
    LOVE | EVIL | REMEDY | CHOICE | RESTORATION
  • Loading...