+ Reply to Thread
Page 8 of 9 FirstFirst ... 6 7 8 9 LastLast
Results 106 to 120 of 124

Call in the Cavalry - 2018

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

    Re: Call in the Cavalry - 2018

    aahh good catch, Dave, OP was in "My Posts"

    Thanks
    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

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.

  2. #107
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2007
    Posts
    8,237

    Re: Call in the Cavalry - 2018

    Sorry, but I absolutely have no patience for this thread.

    Probably my fault, but I can't follow...Can somebody else help?

    Note: A better description now exists.
    Last edited by jeffreybrown; 09-25-2018 at 08:02 PM.
    HTH
    Regards, Jeff

  3. #108
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office Professionsl Plus 2016- work; 2012 for Mac at home
    Posts
    4,332

    Re: Call in the Cavalry - 2018

    Can anyone help this person? I can't figure out what they want and they PM'd me but I'm still unclear what they want.
    https://www.excelforum.com/excel-for...s-formula.html
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam C

  4. #109
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - Office 365
    Posts
    8,868

    Re: Call in the Cavalry - 2018

    I keep seeing gibberish. What am I missing?

    Anyone see the patterns in WB and what OP is talking about?

    https://www.excelforum.com/excel-gen...ml#post4981416
    Dave

  5. #110
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - Office 365
    Posts
    8,868

    Re: Call in the Cavalry - 2018

    I don't have much statistics experience. I tried to 'dumb' my way through the logic of the formulas. I thought I had succeeded. I was wrong.

    It appears I may be doing more harm than good here.

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

  6. #111
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office Professionsl Plus 2016- work; 2012 for Mac at home
    Posts
    4,332

    Re: Call in the Cavalry - 2018

    This person needs a VBA solution and looks like they posted in the wrong forum.
    https://www.excelforum.com/excel-gen...-1234-5-a.html
    thanks for giving a look-see.

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

    Re: Call in the Cavalry - 2018

    This looks interesting, any VBA takers?
    https://www.excelforum.com/excel-pro...yperlinks.html

  8. #113
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - Office 365
    Posts
    8,868

    Re: Call in the Cavalry - 2018

    This is very strange. Evident floating point seems to spontaneously self correct.

    Any explanations how?

    https://www.excelforum.com/excel-gen...ml#post4985527

  9. #114
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    11,604

    Re: Call in the Cavalry - 2018

    Can someone provide succor to this thread - I'm just not coming up with anything else
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  10. #115
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    4,355

    Re: Call in the Cavalry - 2018

    O.P. didn't want to use any of my suggestions.

    Insists on a VBA solution to provide a specific layout.

    Thread: https://www.excelforum.com/excel-pro...logically.html

  11. #116
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2007
    Posts
    8,237

    Re: Call in the Cavalry - 2018

    Just out of curiosity, since I just pretend to know what I'm doing, is there a better way to make a formula here to extract unique.

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

    Re: Call in the Cavalry - 2018

    Member benishiryo needs some VBA assistance here, please.
    https://www.excelforum.com/excel-pro...ormatting.html

  13. #118
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5,770

    Re: Call in the Cavalry - 2018

    My inclination is to say 'No' to the question about speeding up the execution (post #4), however, I would appreciate a second opinion.
    https://www.excelforum.com/excel-pro...ml#post4991719
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  14. #119
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5,770

    Re: Call in the Cavalry - 2018

    OP would like to be able to return to the original value in a cell containing a drop down (data validation) and have the dependents of that cell (which are drop downs themselves) automatically display blanks. I don't know if a way that can be accomplished using formulas, so I am reaching out the the VBA coders to see if anyone can assist. The file in question is attached to post #15 looking at cell D18 (the dependents are D19:D21). At present the cell is filled by a formula which gives it a default value based on the value in another cell and which will, of course, be overwritten once a selection from the drop down is made.
    https://www.excelforum.com/excel-gen...tion-list.html

  15. #120
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5,770

    Re: Call in the Cavalry - 2018

    OP believes that a VBA solution would be faster than the formula solutions offered. File with formulas applied is in post #3. A faster formula is posted in post #5. Would appreciate a VBA coder taking a look and offering the OP an opinion/solution.
    https://www.excelforum.com/excel-pro...ml#post4991691

+ Reply to Thread
Page 8 of 9 FirstFirst ... 6 7 8 9 LastLast

Thread Information

Users Browsing this Thread

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

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