+ Reply to Thread
Results 1 to 28 of 28

It's the small adjustments that will kill you

  1. #1
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,705

    It's the small adjustments that will kill you

    Just a small adjustment. 17 posts and counting.

    smalladjustment.jpg
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: It's the small adjustments that will kill you

    Commercial Services ?



  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: It's the small adjustments that will kill you

    Or this one... 89 posts and counting... (I'd have walked away long before 89 posts...)

    https://www.excelforum.com/excel-for...d-numbers.html
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: It's the small adjustments that will kill you

    Quote Originally Posted by Glenn Kennedy View Post
    Or this one... 89 posts and counting... (I'd have walked away long before 89 posts...)

    https://www.excelforum.com/excel-for...d-numbers.html
    It's morbid curiosity that keeps me going sometimes.
    Dave

  5. #5
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: It's the small adjustments that will kill you

    Quote Originally Posted by 6StringJazzer View Post
    It's the small adjustments that will kill you
    Yep, those are the ones.. often they start so innocently,... you’d never guess what lies ahead ....
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: It's the small adjustments that will kill you

    I think there's a pattern: whenever someone assesses their own issue as a "small" one or one that must be "easy" to resolve, it's usually because (a) they know it isn't, really, but don't want to put potential helpers off, or (b) they are clueless.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: It's the small adjustments that will kill you

    What amuses me (is that the right term? hmm yes, lets just say amuses) is when the OP starts out with what really is a simple question, and when you answer - oh, I forgot to mention, I also need it to do (****) insert task ...

    or, the other 1...well, I made my sample data simple, but in reality, it bares no resemblance at all to my real data...
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: It's the small adjustments that will kill you

    Yes, that's the forum equivalent of a shaggy dog story ...

  9. #9
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: It's the small adjustments that will kill you

    I think we have all noticed that when you take the time and effort to carefully prepare a question , then you often answer all or best part of your question yourself. So it is a sad fact that in many case the short badly detailed question is just a quick “trying your luck” to see if someone will do your work for you.
    But not always , it can be very difficult and frustrating sometimes to know how / what to ask when you are new or asking in a subject area you know nothing about. . I have asked in Forums on subjects I know nothing about, and you can really get hammered by intolerant, impatient helpers.
    We definitely have a higher level of patience and tolerance than most.
    _..._
    Quote Originally Posted by AliGW View Post
    ..... or (b) they are clueless.
    ... OP is given a job to do .. He has not quite figured out what he is being askled to do. Someone who does understand what needs to be done helps him and gives him the code to do it. The OP posts the code and says it does not work. The OP gives no more detail as he has not figured out yet what it is supposed to do.. Lol.... . You end up telling the OP what his question is .
    In RL you would probably tell him to go and make the coffee or sweep the yard clean...
    Last edited by Doc.AElstein; 03-30-2017 at 03:50 AM.

  10. #10
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    575

    Re: It's the small adjustments that will kill you

    Or just provide a link to the commercial services forum.

    (<---- Mercenary contractor)

  11. #11
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: It's the small adjustments that will kill you

    Quote Originally Posted by AliGW View Post
    I think there's a pattern: whenever someone assesses their own issue as a "small" one or one that must be "easy" to resolve, it's usually because (a) they know it isn't, really, but don't want to put potential helpers off, or (b) they are clueless.
    Yes. I have found the phrase "Basically what I need ...." is also a tip-off.

  12. #12
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,705

    Re: It's the small adjustments that will kill you

    Quote Originally Posted by Doc.AElstein View Post
    I think we have all noticed that when you take the time and effort to carefully prepare a question , then you often answer all or best part of your question yourself.
    Very true. This has happened to me several times when composing my own question for this forum. Maybe I'm just really **** retentive but it seems like few people have the discipline to write a really good question. (OTOH I resolved a CS question last week that was very well-written.)

    I have also noticed that when a question says, "I hope this makes sense," it almost never does.

  13. #13
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: It's the small adjustments that will kill you

    To ask a really good question you need to know most of the answer before you start asking.

    Alf

  14. #14
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: It's the small adjustments that will kill you

    Another thought.

    I wonder how many of the "easy", "small", "basically" and "hope this makes sense" tip offs aren't due to OPs feeling intimidated by what they see here. I know I was when I first came to the forum .... well I still am sometimes.

    Does that make sense? Hee, hee, hee.

  15. #15
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: It's the small adjustments that will kill you

    Quote Originally Posted by FlameRetired View Post
    Another thought.

    I wonder how many of the "easy", "small", "basically" and "hope this makes sense" tip offs aren't due to OPs feeling intimidated by what they see here. I know I was when I first came to the forum .... well I still am sometimes.

    Does that make sense? Hee, hee, hee.

    You... and me, too!!

  16. #16
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: It's the small adjustments that will kill you

    And me, too, also, as well

    Some probably boil down to the fact that if you dont even know what tools exist, how would you know what to ask for?

  17. #17
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,705

    Re: It's the small adjustments that will kill you

    I'm not talking about the symptom of someone who doesn't know the tool needed to solve a problem. That is actually the kind of question I love.

    The problem is more when people don't really clearly understand the problem they are trying to solve in the first place, so they really don't even know what to ask. The description of the problem is so scattered that it's hard to even figure out what they need. Here is a made-up example, but I have seen questions that are incredibly similar to this:

    I have three sheets and the names on the first sheet have to match the numbers on the third sheet. But the names on the second sheet are in a different order. How do I get the numbers I need?

  18. #18
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    206

    Re: It's the small adjustments that will kill you

    Quote Originally Posted by 6StringJazzer View Post
    Here is a made-up example, but I have seen questions that are incredibly similar to this:

    I have three sheets and the names on the first sheet have to match the numbers on the third sheet. But the names on the second sheet are in a different order. How do I get the numbers I need?
    Lol: https://www.excelforum.com/excel-for...ml#post4617010

    I don't know how you answered that one with nothing to go on.

  19. #19
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: It's the small adjustments that will kill you

    Quote Originally Posted by Raphaelp View Post
    Lol: https://www.excelforum.com/excel-for...ml#post4617010

    I don't know how you answered that one with nothing to go on.
    It's all done with mirrors and crystal balls

  20. #20
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: It's the small adjustments that will kill you

    Quote Originally Posted by FDibbins View Post
    And me, too, also, as well

    Some probably boil down to the fact that if you dont even know what tools exist, how would you know what to ask for?
    Indeed. i never saw the point of PRODUCT, until yesterday (never having had the need to find out how to use it)

    https://www.excelforum.com/excel-for...ml#post4618181

    So thanks, MrS....

  21. #21
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: It's the small adjustments that will kill you

    Quote Originally Posted by FDibbins View Post
    It's all done with mirrors and crystal balls
    I guess the years of, and level of, experience of some Member is such that in some cases they can recognise a project and guess what is wanted even when virtually no details are given. This ability makes the rest of convinced that they can mind read.
    But an OP that badly prepares his question and gets and just takes a working solution on a plate really cheats himself of a great chance to learn...
    Quote Originally Posted by FDibbins View Post
    .....probably boil down to the fact that if you dont even know what tools exist, ..
    I wish someone had rammed VBA down my throat when I started with Excel, I probably would have saved a year’s worth of time. An Excel spreadsheet is just a very restricted version of some VBA codes, at least in the way it is used by many people.
    Last edited by Doc.AElstein; 03-31-2017 at 02:47 AM.

  22. #22
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: It's the small adjustments that will kill you

    Very true Alan. "In the land of the blind, the 1-eyed man is king"

  23. #23
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831
    Hi !

    Sometimes it's really hard to answer and stay cool :

    few days ago on a local forum I've been warned my code does not work on rainy days !

    So I had no word to answer except expecting sunny days ‼

  24. #24
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: It's the small adjustments that will kill you

    RE: the main topic, this is an ideal example of "Feature creep" and it is undoubtedly ushered in by the "...one more thing" introduction.

    My common answer when the new thing is truly a new feature is often, "That seems like a new idea for a new thread. Let's mark this one solved."
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  25. #25
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: It's the small adjustments that will kill you

    Or
    _....." That sounds like a great idea for a new thread !! - ( Let's mark this one Solved x ) " ..........
    Last edited by Doc.AElstein; 03-31-2017 at 11:59 AM.

  26. #26
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,705

    Re: It's the small adjustments that will kill you

    Quote Originally Posted by Raphaelp View Post
    Lol: https://www.excelforum.com/excel-for...ml#post4617010

    I don't know how you answered that one with nothing to go on.
    Hey, I was awesome in that thread

  27. #27
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    small adjustments to kill your strings ( who is yous" ) :-nub of a song in there :)

    Quote Originally Posted by Awesome View Post
    Hey, I was Awesome in that thread
    ...Lol
    _.......(Edit: who is Hey ... )



    Us.. Yous.. Wot?
    Nub of a Song: who is yous "who made yous" _Who_Is_Yous yeh..... awesome? ....wot you think?? I can play it .... The drums.. ( and sing it ) Can you Guitar it .. awesome, ..hey - ( need to cut out a string or two or three ? ) ?? Let's cover it :-) !
    Last edited by Doc.AElstein; 03-31-2017 at 06:31 PM. Reason: Or Some stuff

  28. #28
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: It's the small adjustments that will kill you

    Quote Originally Posted by 6StringJazzer View Post
    Hey, I was awesome in that thread
    Yes you were. I was afraid to post that here until you said it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA adjustments needed for Mac
    By AndrewMac in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-08-2016, 04:30 AM
  2. [SOLVED] Mystified by name range adjustments
    By AB33 in forum Excel General
    Replies: 12
    Last Post: 09-05-2012, 03:32 PM
  3. [SOLVED] Rent CPI adjustments
    By Lazy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-18-2009, 04:04 AM
  4. Scroll bar adjustments
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2008, 12:35 PM
  5. formula adjustments
    By AlienBeans in forum Excel General
    Replies: 1
    Last Post: 09-01-2006, 05:38 PM
  6. [SOLVED] Time Zone Adjustments
    By lsmft in forum Excel General
    Replies: 4
    Last Post: 03-11-2006, 12:46 PM
  7. [SOLVED] Adjustments
    By Andy in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 01-21-2005, 11:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1