+ Reply to Thread
Page 1 of 9 1 2 3 ... LastLast
Results 1 to 15 of 129

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
    11,179

    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 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    30,909

    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!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward 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
    11,179

    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 Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365
    Posts
    10,500

    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
    5,659

    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 Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    XL 2010,2016
    Posts
    11,815

    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
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,187

    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
    5,533

    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 Capricci

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

    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
    47,947

    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

  11. #11
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365
    Posts
    10,500

    Re: Call in the Cavalry - 2019

    OK.
    Got in over my head again.

    OP has a counting mission. I can not seem to interpret the criteria.


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

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

    Re: Call in the Cavalry - 2019


  13. #13
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    15,779

    Re: Call in the Cavalry - 2019

    Anybody up for this OP's situation? I originally thought that Power Query was the answer, but now I am not sure, perhaps a complex VBA? I am at a loss.

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

  14. #14
    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
    5,533

    Re: Call in the Cavalry - 2019

    checking to see if someone wants to look at this person's issue.
    https://www.excelforum.com/excel-for...ice-value.html
    he has PM'd me twice about helping him. I told him first time that I don't open macro enabled sheets often d/t work firewall issues.
    then he uploaded a .xls sheet and I told him I can't open those because I get an error notice if they are from outside sources, even if I try to save them first or change the extension.
    anyway, I have no idea why he came to me but hopefully someone can help him.

  15. #15
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    14,761

    Re: Call in the Cavalry - 2019

    Quote Originally Posted by Sambo kid View Post
    checking to see if someone wants to look at this person's issue.
    https://www.excelforum.com/excel-for...ice-value.html
    he has PM'd me twice about helping him. I told him first time that I don't open macro enabled sheets often d/t work firewall issues.
    then he uploaded a .xls sheet and I told him I can't open those because I get an error notice if they are from outside sources, even if I try to save them first or change the extension.
    anyway, I have no idea why he came to me but hopefully someone can help him.
    This guy PM'ed me too. People are not really supposed to do that.
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

+ Reply to Thread
Page 1 of 9 1 2 3 ... 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