Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: I love it when...
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2016
    Posts
    111
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Cool I love it when...

    ...I create a large post in the VBA question area, add the code, and go through all the trouble to ask the question...mind you I've tried a few things before posting because I want to figure it out on my own...and then right before I post, I get an idea, and BAM, I don't need to post the question any longer.

    Very satisfying.

  2. #2
    Board Regular
    Join Date
    Nov 2006
    Location
    London
    Posts
    8,149
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    2 Thread(s)

    Default Re: I love it when...

    When looking for help the answer lies in describing very carefully the problem you have and ensuring others can clearly understand it.
    Just describing a problem with little care leads to "tunnel vision". People very often see the output they're expecting only when a condition is TRUE and there's no thought whatsoever when that condition is FALSE.

    e.g. "If A1 is 1, I want B1 to be 2"
    And what should B1 be if A1 does NOT happen to be 1, we'll just guess shall we?

    I used to write reports (programs) for departments and people would fill in a request form to list the fields they wanted on the report. Very often they forgot to include everything they wanted. So I changed the form so you could not only list the fields but "draw" what you expected the report to look like. This meant they looked at the request a second time and in a completely different way and often included fields they'd originally left off the list.

    Glad you solved your problem.

  3. #3
    .
    Join Date
    Mar 2014
    Location
    Suffolk, UK
    Posts
    3,628
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I love it when...

    I love it when people include "easy" in a thread title asking about a problem they clearly can't solve themselves - side-splitting!!!

  4. #4
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    35,207
    Post Thanks / Like
    Mentioned
    92 Post(s)
    Tagged
    33 Thread(s)

    Default Re: I love it when...

    Quote Originally Posted by AliGW View Post
    I love it when people include "easy" in a thread title asking about a problem they clearly can't solve themselves - side-splitting!!!
    I absolutely hate when people simplify a problem for us and then, when the solution we post for that simplified data/setup doesn't work, then they come back and tell us what their actual data is and how it is laid out. So what are they thinking... Excel is so simple that once they see an answer it can easily be scaled up to solve any problem?
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See Part B here.

  5. #5
    Administrator starl's Avatar
    Join Date
    Aug 2002
    Location
    Everywhere!
    Posts
    5,859
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I love it when...

    Rick! this thread is about LOVE, not hate.

    K99 - I have done that so many times, I've lost count. But it's taught me that if I'm scratching my head over the obvious for 5 minutes, ask someone. By the time you're finished talking - you'll see the answer. Or they point out the simple answer to you (which you knew) and you can give yourself a DUH! moment. I do that too, lol.

    Ali - thank you

    hitbid - glad you figured it out. Though, if you had posted then figured it out- posting the solution just helps make the site better! That's why clear, specific titles are important. And why we prefer to keep everything on site (no attachments, for example). It just helps make the site more useful, which brings more people in, which helps pay for the server and keep it free.
    Ok, Admin rant over

    TGIF!!

  6. #6
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    35,207
    Post Thanks / Like
    Mentioned
    92 Post(s)
    Tagged
    33 Thread(s)

    Default Re: I love it when...

    Quote Originally Posted by starl View Post
    Rick! this thread is about LOVE, not hate.
    Okay, change the work "hate" in my message to "love" (but then make sure to read it with a sarcastic tone afterwards).
    Last edited by Rick Rothstein; Jun 3rd, 2016 at 01:25 PM.
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See Part B here.

  7. #7
    Administrator starl's Avatar
    Join Date
    Aug 2002
    Location
    Everywhere!
    Posts
    5,859
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I love it when...

    *lol* that's the spirit

  8. #8
    Board Regular
    Join Date
    Jan 2016
    Posts
    111
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I love it when...

    Quote Originally Posted by starl View Post
    hitbid - glad you figured it out. Though, if you had posted then figured it out- posting the solution just helps make the site better! That's why clear, specific titles are important. And why we prefer to keep everything on site (no attachments, for example). It just helps make the site more useful, which brings more people in, which helps pay for the server and keep it free.
    Ok, Admin rant over

    TGIF!!
    TGIF!

    Great point. In the past (2-3 weeks since I joined), I have just stated that I figured it out, and haven't always posted the solution. Good call for next time, thanks.
    Last edited by hitbid; Jun 3rd, 2016 at 07:51 PM.

  9. #9
    Board Regular Darren Bartrup's Avatar
    Join Date
    Mar 2006
    Location
    Nottingham (UK)
    Posts
    1,258
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I love it when...

    Rick - that happens all the time at work even when I push for more information. Love it. :D
    Using Office 2003 & 2010,

    I'm 1 of the 10 people that don't understand binary. Guess that means the other 1001 do.

    No answer to your post?
    Get someone to read it - does it make sense or does it sound like gibberish?

  10. #10
    MrExcel MVP Jonmo1's Avatar
    Join Date
    Oct 2006
    Location
    Bryan, TX
    Posts
    44,057
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I love it when...

    I love how Vlookup is the solution to everything (it's the greatest thing since sliced bread).

    So I'm using Vlookup to Sum......but it doesn't work..
    Last edited by Jonmo1; Jun 10th, 2016 at 12:02 PM.
    Use the MrExcel HTML Maker to post nicely formatted tables in your forum posts.
    Find a link in post number 31

    The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.

    Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
    Ferris Bueller A.K.A. John Hughes, 1986

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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