+ Reply to Thread
Results 1 to 10 of 10

Call in the Cavalry - 2019

  1. #1
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    10,210

    Call in the Cavalry - 2019

    Am I allowed to start a Call in the Cavalry thread for the new year? In the spirit of "it is easier to ask forgiveness rather than permission", I'm going to start a Call in the Cavalry thread for the new year.

    I do not have the business/financial know how to advise this OP on calculating interest on a payment plan. XIRR() seems like the obvious first choice, but I do not know if it is really applicable to the specific scenario being presented. Anyone with knowledge of such accounting issues contribute some financial expertise?

    Edit because, like an idiot, I failed to include the link to the thread in question: https://www.excelforum.com/office-36...ease-help.html
    Last edited by MrShorty; 01-03-2019 at 01:44 PM. Reason: add link to thread
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    22,210

    Re: Call in the Cavalry - 2019

    Thread now stuck!

    You've not provided a link ...
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    10,210

    Re: Call in the Cavalry - 2019

    This is on a MAC, and the OP is having trouble array entering the formula: https://www.excelforum.com/excel-for...ml#post5037299 I think I have described the problem correctly, but perhaps someone who works on Macs can confirm and/or clarify how to array enter array formulas.

  4. #4
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365
    Posts
    9,353

    Re: Call in the Cavalry - 2019

    A conditional formatting problem has me stumped.

    I almost never venture into these specialized areas of CF.
    OP wants to apply icon sets to two merged cells. Even after un-merging them I can't find a solution.
    Also CF rules for his criteria don't seem doable for icon sets. Hope I'm wrong.

    Conditional Formatting with a twist
    Dave

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

    Re: Call in the Cavalry - 2019

    Solver issue here:
    https://www.excelforum.com/excel-for...ml#post5041509

    I believe that I answered the original question but upon changing one of the cells that holds the constraint, a linearity error comes up.

    I don't understand the 3 different solver methods enough to say why. Evolutionary seems to work.

    Edit: I believe O.P. is happy with the result using the Evolutionary method.
    Last edited by 63falcondude; 01-10-2019 at 01:10 PM.

  6. #6
    Forum Guru davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    XL 2010,2016
    Posts
    11,511

    Re: Call in the Cavalry - 2019

    Anybody understand what is going on here??
    https://www.excelforum.com/excel-pro...lumn-data.html

  7. #7
    Forum Expert
    Join Date
    06-08-2012
    Location
    swindon, england
    MS-Off Ver
    Excel 2016 / Windows 10
    Posts
    3,922

    Re: Call in the Cavalry - 2019

    Had what I thought was an easy follow up question until I realised I had misread it.

    https://www.excelforum.com/excel-for...-function.html

    OP is looking to identify the earliest possible combination of 3 distinct rows. The rows identified should be unique to each other, not the whole table (this was the bit I misunderstood).
    Follow up question starts at post #4, potential curveball identified in post #13.

  8. #8
    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,610

    Re: Call in the Cavalry - 2019

    This person needs some help and the post doesn't seem to be drawing much attention AND, I am in the middle of reports at work so don't have the time.
    https://www.excelforum.com/excel-gen...and-group.html
    What has me a bit concerned is that he's PM'd me twice wanting to work only with me and asking about the business I am in, this might be completely innocuous but maybe not so you might want to be careful.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam C

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    22,210

    Re: Call in the Cavalry - 2019

    If he PMs you again asking for help personally, please report the PM using the Report button and we shall deal with it, as it's against this forum's rules and code of conduct.

  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
    45,986

    Re: Call in the Cavalry - 2019

    Any VBA members feel like taking a look here please?
    https://www.excelforum.com/excel-pro...tra-error.html
    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

+ Reply to Thread

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