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

Call in the Cavalry - 2017

  1. #121
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,320

    Re: Call in the Cavalry - 2017

    can anybody help this guy? I don't have the patience https://www.excelforum.com/excel-pro...all-stack.html
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  2. #122
    Forum Expert
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    4,010

    Re: Call in the Cavalry - 2017

    I imagine that if this can be solved, it will require VBA. https://www.excelforum.com/excel-for...ml#post4742404
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

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

    Re: Call in the Cavalry - 2017

    I am not sure how much more can be done here. The OP find the "helper columns" in the proffered solution "clunky" and is wondering if there are "better" ways to get this exponential moving average. As a fan of helper cells and helper columns, I thought the example solution was rather simple and easy to follow (anything but clunky). If anyone has additional thoughts, the OP would probably appreciate a different set of eyes on this one.
    https://www.excelforum.com/excel-for...g-average.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #124
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - 2013
    Posts
    6,433

    Re: Call in the Cavalry - 2017

    I've "thrown in the towel" here. I no longer know what questions to ask. Maybe someone can decipher the OP's intended logic.

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

  5. #125
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - 2013
    Posts
    6,433

    Re: Call in the Cavalry - 2017

    I seem to recall there is an issue with a build number.
    Note: I am using Microsoft Office Home and Student 2016 Version 1707 (Build 8326.2096)
    OP is having problems with formulas in forum downloads. I don't recall what the version issue is, and I don't know if this is related.

    Anyone know?

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

  6. #126
    Valued Forum Contributor 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,135

    Re: Call in the Cavalry - 2017

    I believe that there is not enough info to go off of. Perhaps I am missing something.

    https://www.excelforum.com/excel-for...a-formula.html

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

    Re: Call in the Cavalry - 2017

    This OP is seeing some unusual behavior in his copy of Excel: https://www.excelforum.com/excel-cha...ml#post4749655 I don't know if it is something in his installation or in the file. Has anyone else seen these behaviors that can suggest what to look for?

  8. #128
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    10,268

    Re: Call in the Cavalry - 2017

    Anyone able to group rows including an empty row here?
    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

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

    Re: Call in the Cavalry - 2017

    I'm not sure but I think this has been done - can someone help?

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

    Re: Call in the Cavalry - 2017

    Anybody have an idea how to solve this in VBA?
    HTH
    Regards, Jeff

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

    Re: Call in the Cavalry - 2017

    Could use some formula help here!

  12. #132
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - 2013
    Posts
    6,433

    Re: Call in the Cavalry - 2017

    I am certain this one needs one or more change event procedures to sort a rather large collection of tables.

    It took me a long time to sift through this thread. (I made a lot of wrong "guesses" along the way.) I have no doubt now that VBA is the only way this can be done. Unfortunately I don't know enough VBA.

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

  13. #133
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2007
    Posts
    7,496

    Re: Call in the Cavalry - 2017

    This seems like a long stretch for a formula. Could somebody offer some thoughts?

  14. #134
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - 2013
    Posts
    6,433

    Re: Call in the Cavalry - 2017

    OP wants to assign names to ranges with offset row headers. Can this be done with VBA?

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

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

    Re: Call in the Cavalry - 2017

    Anyone able to sort this one out with either a formula or a macro, please? It's about averaging speed over 15-minute intervals.
    (gurus only - CS thread)

    https://www.excelforum.com/commercia...-executed.html
    Last edited by JBeaucaire; Yesterday at 03:06 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

+ 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