+ Reply to Thread
Results 1 to 14 of 14

Tips on How To Get Quick & Good Answers

  1. #1
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,127

    Tips on How To Get Quick & Good Answers

    I'm trying to do this so that i can paste this link to OPs whenever needed. If Admins/Mods find this useful, you guys can probably sticky this thread.

    1. Provide a sample Excel file. It is generally preferred to a picture or a thread full of words

    2. Sample file should:
    i) indicate which cells you want the answers in.
    ii) contain Before/After or desired answers.
    iii) explain how those in (ii) are arrived, in layman's terms.
    additional points to consider:
    iv) colour the cells on how /where to get the answers (sometimes not possible though)
    v) try to maintain same cell references as actual file so that you do not have to change the formulas we provide when you transfer back to your own file.
    vi) have a few examples/scenarios (not just 1 row so that we can see a pattern, and not your whole spreadsheet of thousands of rows where it is unnecessary).
    vii) make sure you remove sensitive data

    having all of the above ensures that you don't have to write long descriptions & it helps us zoom straight into the problem. here are some examples that reiterate my points.

    Name:  eg1.jpg
Views: 385
Size:  35.0 KB
    Name:  eg2.jpg
Views: 405
Size:  30.6 KB
    Name:  eg3.jpg
Views: 447
Size:  36.2 KB
    Last edited by benishiryo; 07-17-2013 at 02:58 AM.

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,996

    Re: Tip on How To Get Quick & Good Answers

    I think you have pretty much covered it Ben, I would just add that the sample workbook should not contain any sensitive info. This is the "canned reply" I use...

    I would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that

    On a side note (just pulling your leg), I like you you say to not upload pics, and then upload pics yourself LOL
    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

  3. #3
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,127

    Re: Tip on How To Get Quick & Good Answers

    yeah i use the canned replies too, but somehow people simply upload a sample file & that's it. no before/after. so i thought the pictures might help. trying to display in the thread, but can't do it. i'll add the removal of sensitive data to my OP. thanks

  4. #4
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Tip on How To Get Quick & Good Answers

    I remember there was a way to actually show the pics in the post instead of having to click on them ben. If you could do that then it would be much more visually appealing. I did this only once for the July competition and it worked out really well. Unfortunately I have forgotten how to accomplish the task again.
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  5. #5
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,127

    Re: Tip on How To Get Quick & Good Answers

    @abousetta:
    yes i'm trying to do that too, but i can't seem to do it. i followed MarvinP's thread here:
    http://www.excelforum.com/excel-tips...-a-thread.html
    when i'm doing step 7, it says "error: Invalid File". and his picture link was not downloaded when clicked. mine are. don't know where's the difference in uploading. i had to right-click my picture links & Copy Link Address to get the link.

  6. #6
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Tip on How To Get Quick & Good Answers

    Try usig jpeg instead of png files... if I remember correctly, that's the type the system accepts

  7. #7
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Tip on How To Get Quick & Good Answers

    Here's the example I was talking about http://www.excelforum.com/excel-tips...d-vlookup.html

  8. #8
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,127

    Re: Tips on How To Get Quick & Good Answers

    @abousetta:
    yeah i know what you mean & i want to replicate that too like i mentioned in post #3, but can't seem to do it. i have converted them all to jpeg & still no luck. i've asked arlu for assistance.

  9. #9
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,250

    Re: Tips on How To Get Quick & Good Answers

    OK Benishiryo,

    I took your picture file of eg1.gif and copied it to my desktop. I then saved it up to the ExcelForum website using Advanced Attach a file.

    I could then look or manage my attachments to find it was located at:
    http://www.excelforum.com/attachment...1&d=1374198671

    Then I clicked on the Icon called "Insert Image" above the message area.
    This dialog has two tabs
    1. From your Computer
    2. From a URL. I clicked on this tab and Pasted the URL link above.

    This dialog has changed in that it used to work and now gives an error message of "invalid file type". I'll report this to Arlette to see if the Tech Team can look at the changes.

    @ Benishiryo - you are correct, I can no longer display a gif file in a post with the above change.

    You are going to love this.....
    While doing a PM to Arlette and trying to add a URL Image file to my PM post, it seemed to work. I'd say again it looks to be a bug in the Tech Team's programming code.

    I PMed Arlette, DFibbins and Benishiryo in the message. I really hope they can see the image in the PM to show it works sometimes.....
    Attached Images Attached Images  
    Last edited by MarvinP; 07-18-2013 at 10:37 PM.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,996

    Re: Tips on How To Get Quick & Good Answers

    I can see a cute lil before and after pic

  11. #11
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Tips on How To Get Quick & Good Answers

    ??? I'm confused... Marvin I don't see the picture... what am I missing?

  12. #12
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,147

    Re: Tips on How To Get Quick & Good Answers

    Yeah i can see the pic in the msg too. I will get this checked.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  13. #13
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Tips on How To Get Quick & Good Answers

    Why not just enable the BB code IMG tags for this specific forum?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  14. #14
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,147

    Re: Tips on How To Get Quick & Good Answers

    Thanks for the suggestion, Tony. Will get this checked.

+ 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. [SOLVED] Quick question about automatic row deletion (should be very quick and easy!!)
    By poptart141 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-09-2013, 12:56 PM
  2. [SOLVED] Count the number of matches in a row of one word answers with a row of correct answers
    By flammer4 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-03-2012, 01:17 PM
  3. Answers YES and NO
    By Michelle66 in forum Excel General
    Replies: 3
    Last Post: 12-17-2011, 10:00 PM
  4. Quick Question QUick Answer
    By ccraig61 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2006, 09:34 PM
  5. Quick question - quick answer about assigning shortcut keys
    By funkymonkUK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2005, 06:05 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