+ Reply to Thread
Page 1 of 11 1 2 3 ... LastLast
Results 1 to 15 of 155

Call in the Cavalry - 2018

  1. #1
    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
    25,389

    Call in the Cavalry - 2018

    You wanted it - here it is!

    Here's last year's: Call in the Cavalry - 2017
    Last edited by AliGW; 01-03-2018 at 02:29 AM.
    Ali


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

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    Are you new to Power Query and don't know what to do with the code you've been given? Have a look 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.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,611

    Re: Call in the Cavalry - 2018

    Thanks Ali
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    46,917

    Re: Call in the Cavalry - 2018

    Thanks for the new thread Ali
    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

  4. #4
    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
    25,389

    Re: Call in the Cavalry - 2018

    No probs, chaps!

  5. #5
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,643

    Re: Call in the Cavalry - 2018

    What's the help you want ??



  6. #6
    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
    25,389

    Re: Call in the Cavalry - 2018

    What do you mean???

    Or are you joking?

  7. #7
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,643

    Re: Call in the Cavalry - 2018

    Just make a guess

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

    Re: Call in the Cavalry - 2018

    OK - thanks for clarifying.

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

    Re: Call in the Cavalry - 2018

    I don't know if this is quite yet at a "cavalry" point (because no one has answered, yet). https://www.excelforum.com/excel-for...r-columns.html
    My reaction to the OP's mockup tables is that they look exactly like pivot tables, using QUARTILE() functions instead of the usual SUM/COUNT/AVERAGE/... functions that are readily available in the PT options. Obviously, a QUARTILE(IF(...)...) array function should be able to work. Before suggesting that, though, I was hoping someone could tell me if it is possible to do this using a pivot table instead.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

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

    Re: Call in the Cavalry - 2018

    Not sure I know how to continue this thread with a formula solution.

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

    My thought would be to create a unique list from C11:C20, E11:E20 etc and then use the helper column, but not that good with the frequency formula which I suspect is needed.

    But then again, maybe not. Any help would be appreciated.
    HTH
    Regards, Jeff

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

    Re: Call in the Cavalry - 2018

    The formula works fine until an external data feed appends in such a way that changes the formula range references. Anyone familiar with data connections or SQL issues?

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

  12. #12
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,429

    Re: Call in the Cavalry - 2018

    I Know what to do in this thread: https://www.excelforum.com/excel-gen...ml#post4820685

    But I can't get TEXT function work in VBA...
    Does anybody has a clue?

    Please Login or Register  to view this content.
    First formula returns correct number (606) that I need to format as 4 digits (within formula, not cell formatting).

    However,

    Please Login or Register  to view this content.
    returns error 1004 (Unable to set the FormulaArray property of Range class).
    Attached Files Attached Files
    Last edited by zbor; 01-15-2018 at 05:54 AM.

  13. #13
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,083

    Re: Call in the Cavalry - 2018

    Hi,

    Your formula is going over the 255 character limit for FormulaArray. Fortunately, that is only down to the spaces added for readability, so you can reduce it to:
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  14. #14
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,611

    Re: Call in the Cavalry - 2018

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

    anyone want to have a crack at this one?
    using VBA to change
    XY scatter chart marker fill to gradient or
    using bubble change gradientstyle and direction

    just cant see to find the right combination
    another quirk with excel in my books
    any body know a work around?

  15. #15
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,429

    Re: Call in the Cavalry - 2018

    Quote Originally Posted by xlnitwit View Post
    Hi,

    Your formula is going over the 255 character limit for FormulaArray. Fortunately, that is only down to the spaces added for readability
    Tnanks xlnitwit.
    Stupid me.. I just had to create it in the sheet I've copy and then it will be there

    And then I've change it with simpler formula where I need it.

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