+ Reply to Thread
Page 1 of 3 1 2 3 LastLast
Results 1 to 15 of 37

Call in the Cavalry - 2020

  1. #1
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010
    Posts
    33,373

    Call in the Cavalry - 2020

    Happy New Year all!
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

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

    Re: Call in the Cavalry - 2020

    Thank you. And you, too.

    Thanks for starting the new 'Call in the Cavalry' thread.
    Dave

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    9,135

    Re: Call in the Cavalry - 2020

    This may need VBA as the OP says they do not want to use helper columns.
    https://www.excelforum.com/excel-for...ml#post5253774
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Office 365 (Win 10 - Work) & Office 365 Subscription Insider (Win 10 - Home)
    Posts
    35,875

    Re: Call in the Cavalry - 2020

    Can anyone help this member with a simple VBA random spelling test from a bank of 250 items?

    https://www.excelforum.com/excel-pro...uage-test.html
    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.

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    9,135

    Re: Call in the Cavalry - 2020

    Higher mathematics and/or programming may be the answer, in either case I have hit the proverbial wall on this one.
    https://www.excelforum.com/excel-for...ml#post5255516

  6. #6
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,067

    Re: Call in the Cavalry - 2020

    https://www.excelforum.com/excel-gen...ing-array.html

    This is getting a bit out of hand with no helper columns. VBA expertise perhaps?
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    9,135

    Re: Call in the Cavalry - 2020

    Either I am not getting the point across or I am not understanding. In any event I would be happy for someone to look.
    https://www.excelforum.com/excel-gen...ml#post5259620

  8. #8
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,067

    Re: Call in the Cavalry - 2020

    Quote Originally Posted by JeteMc View Post
    This may need VBA as the OP says they do not want to use helper columns.
    https://www.excelforum.com/excel-for...ml#post5253774
    The OP never responded, but gave me a rep today (after 13 days) saying "Thank You". All seems good.

  9. #9
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    9,135

    Re: Call in the Cavalry - 2020

    Thank You for looking at the thread Ace_XL. I hope that you have a blessed day.

  10. #10
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    9,999

    Re: Call in the Cavalry - 2020

    I'll readily admit I often do not see the obvious, but does anybody have any thoughts here?

    https://www.excelforum.com/excel-for...ml#post5265871
    HTH
    Regards, Jeff

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

    Re: Call in the Cavalry - 2020


  12. #12
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    9,999

    Re: Call in the Cavalry - 2020

    I'm completely lost here. Anybody have some extra time to see what's going on?

    https://www.excelforum.com/excel-pro...ml#post5271118

  13. #13
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    9,135

    Re: Call in the Cavalry - 2020

    OP would like the months to update automatically in the columns field of the pivot table. Best I was able to offer was manual adjustment using grouping.
    https://www.excelforum.com/excel-cha...ml#post5271405

  14. #14
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    9,999

    Re: Call in the Cavalry - 2020

    I provided a VBA that isn't helping out any better, but the OP is trying to fill in 300,000 rows with a Sumif formula. I suspect it could be recalculating all the way down, but not sure. Any thoughts or is there an alternative?

    https://www.excelforum.com/excel-pro...ml#post5272234

  15. #15
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    9,135

    Re: Call in the Cavalry - 2020

    Would appreciate someone with Power Pivot/Power Query expertise having a look at this one. I probably employed inefficient methods and was not able to come up with a solution to producing subtotals by month per type of investment.
    https://www.excelforum.com/excel-cha...ml#post5273253

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