+ Reply to Thread
Page 9 of 9 FirstFirst ... 7 8 9
Results 121 to 130 of 130

Call in the Cavalry - 2018

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

    Re: Call in the Cavalry - 2018

    O.P. said they were happy with my result but wants it in VBA.

    Thread here:
    https://www.excelforum.com/excel-pro...ction-vba.html

  2. #122
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2016
    Posts
    13,967

    Re: Call in the Cavalry - 2018

    This is out of my wheelhouse. https://www.excelforum.com/excel-gen...ml#post4993838

  3. #123
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily NL, sometimes UK
    MS-Off Ver
    2010
    Posts
    1,881

    Re: Call in the Cavalry - 2018

    I gave a helper-column solution which works, but there should be simpler ways of doing this time subtraction; others have suggested things which should work but the OP gets errors (as do I). My guess is that the OP's Regional Settings might be doing something strange, but I can't work out what.
    https://www.excelforum.com/excel-gen...culations.html
    Regards,
    Aardigspook

    My internet connection can be intermittent, so sometimes I may not reply quickly to questions. Sorry - it's not personal and I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  4. #124
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5,841

    Re: Call in the Cavalry - 2018

    Having an issue with the horizontal axis labels for a chart. The label should show both color and size, which it does when more than one size or color is selected. The issue is when only one color and one size are selected then the label only displays the color.
    https://www.excelforum.com/excel-cha...ml#post4996522
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

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

    Re: Call in the Cavalry - 2018

    OP would like to know if Power Pivot will solve the issue. As I don't have Power Pivot so I can't answer the question and was hoping that someone who is familiar with Power Pivot can.

    https://www.excelforum.com/excel-cha...ml#post4999161

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

    Re: Call in the Cavalry - 2018

    Anybody want to take a crack at some VBA code here?
    HTH
    Regards, Jeff

  7. #127
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    9,978

    Re: Call in the Cavalry - 2018

    I have been looking at this one and helping where I can: https://www.excelforum.com/excel-pro...on-module.html The main problem with my helping is that the OP seems to strongly prefer doing things in VBA rather than the spreadsheet. As one who prefers to do things in the spreadsheet and use minimal VBA, I'm afraid I am not going to be as much help as the OP would like. Now that the project is getting some traction, are there any of you more inclined towards VBA than I am who can follow along and make VBA oriented suggestions? I'll still follow the thread and contribute where I can, but I'm afraid most of my contributions would be uninteresting to the OP.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

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

    Re: Call in the Cavalry - 2018

    Being this is not my strong point, any help here is appreciated.

  9. #129
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 , Office 365
    Posts
    8,984

    Re: Call in the Cavalry - 2018

    OP does not want the Pivot table idea I proposed. I also don't know how to interpret their follow up question.

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

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

    Re: Call in the Cavalry - 2018

    I know of no way to do this with a non-array formula. Any thoughts?

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

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