+ Reply to Thread
Results 1 to 167 of 167

Call in the Cavalry - 2017

  1. #1
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Call in the Cavalry - 2017

    2017 - Happy New Year!

    Call in the Cavalry - 2016
    Last edited by JBeaucaire; 01-02-2017 at 12:57 AM.
    _________________
    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 Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Call in the Cavalry - 2017

    I'm not understanding what the OP wants to do here. It's a conditional count but I'm totally

    https://www.excelforum.com/showthread.php?t=1168440
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Call in the Cavalry - 2017

    Anyone want to assist with this one please?
    http://www.excelforum.com/showthread.php?t=1168391
    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 jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2016

    Anybody want to help with this VBA cleanup?

    http://www.excelforum.com/showthread...38#post4557438
    HTH
    Regards, Jeff

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2017

    If I have followed this one correctly: http://www.excelforum.com/showthread...=1#post4559541 the OP has 1E11 records he would like to perform lookups on. My advice at this point is to use database tools to query the database (databases?), but I do not know databases and Excel. If anyone would care to jump in....
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Call in the Cavalry - 2017

    I am not at all sure what the OP of this thread is after: http://www.excelforum.com/showthread...52#post4560152 Can anyone help?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

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

    Re: Call in the Cavalry - 2017

    I probably should have known that this one would venture into business math concepts that I am ill equipped to answer, but I dove in anyway: http://www.excelforum.com/showthread.php?t=1170019
    I suspect that someone who is business math savvy will quickly recognize what kind of calculation the OP is trying to perform and be able to recommend the correct financial function or other to perform his profit calculation.

  8. #8
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2017

    Anybody have some free time to look at this...

    http://www.excelforum.com/showthread.php?t=1169964

  9. #9
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Call in the Cavalry - 2017

    Anyone use Mac Excel?

    Sounds like a simple conditional formatting question:

    http://www.excelforum.com/showthread.php?t=1170002

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

    Re: Call in the Cavalry - 2017

    Hi all,

    There is a question here regarding subclassing Excel. I have provided some code to the OP but there are certain stability issues apparently and I'm afraid I have devoted as much time as I presently can to this question. If anyone can offer assistance it would be greatly appreciated by both the OP and me.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  11. #11
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Call in the Cavalry - 2017

    Does anyone understand what is going on here?

    http://www.excelforum.com/showthread.php?t=1170029

  12. #12
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Call in the Cavalry - 2017

    Quote Originally Posted by Tony Valko View Post
    I'm not understanding what the OP wants to do here. It's a conditional count but I'm totally

    https://www.excelforum.com/showthread.php?t=1168440
    I think we wants to count the product IDs from the Invoice Numbers in which the "B1" (input given by OP) must be one of the product ID,

    you have the count the Products IDs from the Invoices which contains B1 only in this case
    1003398
    1003584
    1003587
    only have the Product ID 7511025, so you have to count the product IDs from these invoices only
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

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

    Re: Call in the Cavalry - 2017

    This one http://www.excelforum.com/showthread.php?t=1170709 is about a spreadsheet that runs impossibly slow and/or is unresponsive on one particular newer laptop. The spreadsheet seems to work fine on other computers (even my dinosaur). Does anyone have any idea what to look for to explain this behavior?

  14. #14
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2017

    The OP here (http://www.excelforum.com/showthread...88#post4566788 ) turned down the usual "plot a separate series for each condition" approach to conditional charting, preferring instead to use VBA to apply some kind of color map to the data. Since this is beyond anything I ever do (and feel like learning right now), does anyone want to jump in and help?

  15. #15
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Call in the Cavalry - 2017

    Anyone have any thoughts on this:

    VBA error in calculations. Need more decimals?

    The OP generates some values using VBA but they don't agree with the Worksheet functions. The code works ok on my laptop. I can't think what to check
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  16. #16
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2017

    This OP is asking for some complex sorting rules on a moving date criteria. They would prefer not to use formulas ....

    Not even sure I understand the concept properly.

    http://www.excelforum.com/showthread...08#post4567408
    Dave

  17. #17
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2017

    Anybody have a gnatt chart type solution here

  18. #18
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Call in the Cavalry - 2017

    Quote Originally Posted by jeffreybrown View Post
    Anybody have a gnatt chart type solution here
    Hi Jeff,
    Not sure I can help with a Gnatt chart but I'll take a look at it's anagrammatical cousin
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  19. #19
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2017

    Quote Originally Posted by Richard Buttrey View Post
    Hi Jeff,
    Not sure I can help with a Gnatt chart but I'll take a look at it's anagrammatical cousin
    That's quite comical as I was just headed back to this post to correct it as I realized my mistake...

    Thanks

    Unfortunately I don't think I can claim English as my second language...

  20. #20
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Call in the Cavalry - 2017

    Anyone have any suggestions for this: Macro fails after sharing workbook

    The OP has a workbook with macros that works well until he Shares it. It does stuff like Protect and Unprotect the worksheets in order to safeguard formulas and buttons, etc.

    Clearly, you are somewhat limited with a Shared workbook with what you can and cannot do. Anyone think of any alternative approach to help him?

  21. #21
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2017

    It didn't take long for this one to get beyond my feeble skills in database work: http://www.excelforum.com/showthread.php?t=1172051

    as easy as the pivot table was to put together, I might be inclined to suggest a change/calculate event that will refresh the pivot table whenever data is added/removed from the source table.

    I could probably put together a string of calculations (COUNTIFS() to count the values, then LARGE() functions to return the top 5, then lookups to find the sire names for each), but I am a bit sketchy on doing all of that when one could also need a formulaic approach to maintaining a "unique sire name" list and to deal with the scenario when two or more sire names have the same count. Someone who knows this sort of thing better then I could jump in?

  22. #22
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2017

    My feeble skills are obviously no match for the dark side of VBA on this one: http://www.excelforum.com/showthread...37#post4580237 The OP seems to be looking for a way to determine what called a function (a way to access the call stack?). I made my feeble suggestion, but I have no idea if there are better ways to determine how a procedure was called.

  23. #23
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2017

    Need some help please. I just got a phone call that is going to pull me away for the rest of the day.

    Would somebody be so kind as to finish up this thread! Thank you.

  24. #24
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Call in the Cavalry - 2017

    Any VBA experts want to help onthis?

    http://www.excelforum.com/excel-gene...le-sheets.html
    Last edited by jeffreybrown; 02-22-2017 at 07:53 PM. Reason: Updated link

  25. #25
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Call in the Cavalry - 2017

    The OP started with an Excel request, but I suspect doing what he wants can be more fully accomplished in Outlook. I have never really used VBA in outlook so I thought I'd see if anyone here has expertise in that area and wants to give it a looksy? The thread is here
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  26. #26
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2017

    Excel 2007 does not support the built in box and whisker plot the OP is using here http://www.excelforum.com/excel-char...ot-x-axis.html so I cannot see what he is trying. I expect that the right choice of date axis values and configuration should give him/her the desired result, but I cannot do much in my older version of Excel to explain the details of how it should be done. I don't know what version of Excel introduced the built in box and whisker plot, but if one of you with a newer version could have a look.

  27. #27
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2017

    Not so sure I have the solution here

  28. #28
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2017

    This OP finally change the title to their thread so wondering if somebody would be so kind to offer a solution!

  29. #29
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,422

    Re: Call in the Cavalry - 2017

    I drastically cut down the OP's workbook to make a sample to show how the formulas (SUMPRODUCT based) work (post #4). The OP says that while the formulas work, the actual spreadsheet freezes when scrolling or selecting a cell and then reports that it is calculating. The original sheet has 200 columns and just over 2400 rows of data, which along with 2 other sheets weighed in at @ 1.4M (OP attached a zip file to post #1). My instinct is to suggest changing the Calculation Options to Manual, however I have never done this with one of my spreadsheets, and am not sure that this is a good recommendation. I would appreciate someone with experience along the lines working with large amounts of data would give the OP some advice. Thanks.
    http://www.excelforum.com/excel-form...ml#post4598990
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  30. #30
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2017

    I suspect that this thread would greatly benefit from someone who is knowledgeable about database design and use:http://www.excelforum.com/excel-form...ml#post4599452

  31. #31
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2017

    I have done all I can think with formulas, and I can not come up with anything (so far) that doesn't require vast numbers of array formulas. ("1000s" of rows in the source data and up to 40 columns of output) My solution depletes resources.

    I should have seen this one coming.

    http://www.excelforum.com/excel-form...ml#post4600034

  32. #32
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2017

    Anybody have a good solution here?

  33. #33
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2017

    This thread needs a formula expert!
    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

  34. #34
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2017

    I suspect the csv file upload on this one.

  35. #35
    Registered User
    Join Date
    12-17-2016
    Location
    South Wales
    MS-Off Ver
    Excel 2007, 2016
    Posts
    68

    Re: Call in the Cavalry - 2017

    Hi, have just found this thread, hope its ok for me to post to. I've been working on a solution for this post https://www.excelforum.com/excel-pro...ml#post4588735 for a while. The OP wanted code that would translate strings from another programming language into "plain English"! Another forum member and I took it on, producing code that found and replaced specific strings/operators, changed cases, etc. However, I'm struggling with brackets. A "!" before the brackets negates all the operators within the brackets, plus bracketed expressions (and negations) can potentially be nested. If someone with a greater understanding of string conversions could please take a look at this last bit, I'm sure the OP would be grateful - as at present they have a solution that is almost there, but not quite!
    Thanks.

  36. #36
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Call in the Cavalry - 2017

    Hi Good People

    I developed a solution for the OP on this Thread not recognizing the OP was running on the Mac. My Mac is not operational at the moment...can one of you Mac literate persons help?

    https://www.excelforum.com/excel-pro...op-to-end.html
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  37. #37
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Call in the Cavalry - 2017

    I think this is probably a monumental, if not impossible task, but can any VBA expert help?

    https://www.excelforum.com/excel-pro...b-etc-vba.html

  38. #38
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Call in the Cavalry - 2017

    Is any VBA expert able to help with this quoting query? The OP wants to offer selected merchandise dependant on choices made via a selection box, and I think it's going to get a bit unwieldy if done using formulae. Thanks!

    https://www.excelforum.com/excel-pro...n-box-vba.html

  39. #39
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2017

    OP is unable to convert text "dates" to numeric. I also am unable to do it with the upload. It appears Excel 2013 is a common denominator. Excel 2010 poster has no difficulties.

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

  40. #40
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Call in the Cavalry - 2017

    Hi Dave. Here is a spreadsheet with converted dates
    Attached Files Attached Files
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  41. #41
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2017

    Hi AlKey. Thank you. I failed to mention that OP's data is continuously updated. Sorry for the oversight.

  42. #42
    Registered User
    Join Date
    12-17-2016
    Location
    South Wales
    MS-Off Ver
    Excel 2007, 2016
    Posts
    68

    Re: Call in the Cavalry - 2017

    I don't have Excel 2013, but is the issue related to a default date format, as in the second scenario here: https://support.office.com/en-gb/art...4-14c4f124876e ?
    I've noticed that all the dates have a day number greater than 12, so would be invalid if day and month were reversed.

  43. #43
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2017

    @ Trevor_S, thank you.

    That's very observant, and what the link states is very interesting. This might explain a lot.

  44. #44
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Call in the Cavalry - 2017

    Does anyone understand well enough what Rachel is trying to do here?

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

    She is trying really hard to explain how her spreadsheet works and what she wants, which is some sort of cross-tab lookup. Can anyone help at all?

  45. #45
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Call in the Cavalry - 2017

    Quote Originally Posted by AliGW View Post
    Does anyone understand well enough what Rachel is trying to do here?

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

    She is trying really hard to explain how her spreadsheet works and what she wants, which is some sort of cross-tab lookup. Can anyone help at all?
    I'll take a look. It was down to my comments that she's doing a major re-write..
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  46. #46
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Call in the Cavalry - 2017

    Thanks, Glenn.

  47. #47
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Call in the Cavalry - 2017

    Mmm. Wish I hadn't volunteered...

  48. #48
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Call in the Cavalry - 2017

    Would some kind person with Excel 2003 look in on https://www.excelforum.com/excel-for...a-request.html and tell me if they have a problem with the xls file attached to post https://www.excelforum.com/excel-for...l#post4639381?
    Entia non sunt multiplicanda sine necessitate

  49. #49
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Call in the Cavalry - 2017

    I think it is impossible with formula without helper. Do you think so?

    https://www.excelforum.com/excel-for...lculation.html
    Quang PT

  50. #50
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2017

    As usual, pivot tables and chart questions quickly go beyond my level of expertise https://www.excelforum.com/excel-pro...vot-chart.html
    the OP wants to change the name of the data series in the pivot chart. It appears to me that these names are linked through to the source data so that you cannot change them to something other than the text in the source data. Anyone who knows differently?

  51. #51
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2017

    I've corrected the code found here, but the OP is still getting errors I can't duplicate nor resolve. Any ideas?

  52. #52
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2017

    I don't usually get involved with the Commercial Service and this thread is probably why.

    https://www.excelforum.com/commercia...o-another.html

    Anybody have some ideas why this runs fine for me, but the OP says they get errors!!

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

    Re: Call in the Cavalry - 2017

    hey Jeffrey

    replace the debug line with .showalldata and it should be good to go in excel 2011. for whatever reason none of the files in that thread can be opened in excel 2016 without the code being stripped out
    Josie

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

  54. #54
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Call in the Cavalry - 2017

    Quote Originally Posted by jeffreybrown View Post
    I don't usually get involved with the Commercial Service and this thread is probably why.

    https://www.excelforum.com/commercia...o-another.html

    Anybody have some ideas why this runs fine for me, but the OP says they get errors!!
    I get the errors too, running 2016 desktop

  55. #55
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Call in the Cavalry - 2017

    Hope this comes out, I set it to show formulas - this is on Extracted Raw Data sheet...
    C
    D
    1
    Custom SKU Manufacturer SKU
    2
    HDN.J.CH.3.1
    =#REF!A5
    3
    HDN.J.CH.3.2
    =#REF!A6
    4
    =#REF!A7
    5
    =#REF!A8
    6
    =#REF!A9
    7
    =#REF!A10
    8
    =#REF!A11
    9
    HLV.L.BH.4.1
    =#REF!A12

  56. #56
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2017

    @Josie, thanks for the help...it seems to have moved the thread along further.

    @Ford, those actually are not the errors I was referring to. I was referring to the code not running as the OP pointed out. What you noted, those errors were there from the very beginning and not what the OP was seeking. The OP was seeking VBA code to move data.

  57. #57
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2017

    Somebody care to take a crack at this...

  58. #58
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Call in the Cavalry - 2017

    Can't see a Formula solution here without a lot of helper columns. I'm thinking VBA but I could be wrong.

    https://www.excelforum.com/excel-for...-criteria.html
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  59. #59
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Call in the Cavalry - 2017

    Although posted in the access section, the OP is looking for Excel VBA help from what I can tell....

    He wants to scrape some web data by populating a field and hitting search, which is easy enough, but after that I'm not sure, specifically the captcha that is part of the page... anybody able to help him?

    https://www.excelforum.com/access-ta...l-details.html

  60. #60
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Call in the Cavalry - 2017

    You can't do it, that's what captchas are designed to prevent you doing

  61. #61
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Call in the Cavalry - 2017

    Unreliable MATCH that I could not figure it out!

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

  62. #62
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2017

    Can I get one of you VBA guys/gals to help with this one!

    I've come up with a way I understand, but can't get the last piece (so I suppose I don't really understand).

    I can delete all the dups, but when it comes to the last dup, the concatenated results in column M are 101 which are not unique themselves.

    I'm sure I've done this the hard way, so if somebody can help with an easier method I would be very pleased.

    As I understand the OPs requirement, the "brown" shaded rows should be deleted.

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

    Re: Call in the Cavalry - 2017

    thought was simple Max IF formula but because its dealing with Time im getting incorrect results
    https://www.excelforum.com/excel-for...x-formula.html

    can someone see where i am going wrong here?
    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.

  64. #64
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Call in the Cavalry - 2017

    It seems that the OP has decided that your formula works and has now marked the thread as solved.

  65. #65
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2017

    I might be overthinking this one: https://www.excelforum.com/excel-pro...sum-value.html It's a "resource allocation" type problem where the OP wants to divide up several "units" of different types across 6 teams. I suggested a couple of tutorials, but someone might see a "simple" edit of the code the OP started with that will work well enough without going into the more rigorous "find the absolute best" allocation of resources.

  66. #66
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2017

    Anybody want to take a VBA crack at this!

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

    Re: Call in the Cavalry - 2017

    anyone with Win10 and VBA knowledge want to have a stab at tweaking this code
    https://www.excelforum.com/excel-gen...io-help-2.html

    seems to be quirk in windows 10 that it would automatically rotate pictures for some reason

  68. #68
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Call in the Cavalry - 2017

    Anyone heard of/seen/know anything about a Data Sensitivity Bar in (probably) 365?
    https://www.excelforum.com/excel-gen...ivity-bar.html

  69. #69
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2017

    I think the only way left here is going to be VBA.

    An earlier array formula has been simplified non array. There remains a problem (helper column A in sheet 'Result Set (2)'). All I can come up with is a lengthy array formula. OP has just indicated they have 13,129 rows of real data.

    I'm out of ideas.

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

    Edit Solved it. Found simpler helper columns
    Last edited by FlameRetired; 06-18-2017 at 11:53 PM.

  70. #70
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Average of Maximums and Minimums in oscillating wave data

    Follow up question on this post

    https://www.excelforum.com/excel-for...amplitude.html
    note the graphs at bottom of his spreadsheet.

  71. #71
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2017

    I did not catch that the OP was working in Access and not Excel. https://www.excelforum.com/access-ta...ml#post4683383 I gave the best advice I could find on the internet, but I just do not know Access at all. Can anyone chime in with a more knowledgeable answer?

  72. #72
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Call in the Cavalry - 2017

    Hello all
    I'm sort of abusing this thread here to bump my own thread. Threads tend to go stale after a number of replies.
    I got some good answers, I just want more because I think it's a really interesting topic. I can't be the only one who wonders about this.
    https://www.excelforum.com/excel-gen...periences.html
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  73. #73
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Call in the Cavalry - 2017

    Quote Originally Posted by Jacc View Post
    Hello all
    I'm sort of abusing this thread here to bump my own thread. Threads tend to go stale after a number of replies.
    I got some good answers, I just want more because I think it's a really interesting topic. I can't be the only one who wonders about this.
    https://www.excelforum.com/excel-gen...periences.html
    There are 16 posts on that thread, the last being just after you posted this. Instead of posting comments like that here (which for asking for help on question in a thread you are stuck on), rather, just bump your thread there please

  74. #74
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2017

    I did not get that the OP wanted a dashboard here https://www.excelforum.com/excel-cha...filtering.html since I can't do dashboards, can anyone step in and help out?

  75. #75
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2017

    This OP and I are just confusing each other, (probably attributable to my dotage) - anyway hope you can help her.

  76. #76
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2017

    Quote Originally Posted by xladept View Post
    This OP and I are just confusing each other, (probably attributable to my dotage) - anyway hope you can help her.
    You have a link?

    Edit Never mind. It was hiding behind my dotage.
    Last edited by FlameRetired; 07-05-2017 at 04:14 PM.

  77. #77
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2017

    I don't think OP and I are using the same dictionary.

    One or both of us is very confused. I can't tell which it is.

    Feeling brave?

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

  78. #78
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2017

    This OP is trying to figure out some not lat/long coordinate system in Texas: https://www.excelforum.com/excel-gen...own-to-me.html I tried to point out a few pages, but none of them seems to help figure out his specific coordinate examples. Does there happen to be anyone on this forum who is familiar with these different geographic coordinate systems who could step in with more knowledge?

  79. #79
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Call in the Cavalry - 2017

    Anyone able to come up with a macro to help the OP in this thread to rearrange his data slightly?

    https://www.excelforum.com/excel-pro...l#post4699636#

    Thanks.

  80. #80
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2017

    Are any of you versed in pinyin?? I don't know how to help this OP

  81. #81
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Call in the Cavalry - 2017

    Anyone any good with pivot charts? This one has me stumped: https://www.excelforum.com/excel-gen...raph-help.html

  82. #82
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Call in the Cavalry - 2017

    The requirements in this thread have escalated somewhat such that I think VBA is required: https://www.excelforum.com/excel-pro...dashboard.html

    Could a clever coder please take a look?

  83. #83
    Registered User
    Join Date
    06-20-2017
    Location
    london
    MS-Off Ver
    2010
    Posts
    38

    Re: Call in the Cavalry - 2017

    I have a post in commercial services! Need some calvary power to help.

    I am giving 10 points ( all i have to spare!) as a little gesture of incentive...

  84. #84
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Call in the Cavalry - 2017

    songhaegyo this is not really the place to post that kind of thing, plus you need to include the link so others can find it easier

  85. #85
    Registered User
    Join Date
    06-20-2017
    Location
    london
    MS-Off Ver
    2010
    Posts
    38

    Re: Call in the Cavalry - 2017

    i am calling the cavalry... is that wrong?

  86. #86
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Call in the Cavalry - 2017

    Yes, it is - you should bump your CS thread instead. The purpose of this thread is for those of us helping to call for reinforcements if we get stuck helping someone out.

  87. #87
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2017

    This one is text extraction from @ 5000 lengthy paragraphs. Formula solution looks impractical. VBA anyone?

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

  88. #88
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Call in the Cavalry - 2017

    Does anyone want to have a go at this? Looks deceptively easy, but I drew a blank - can't see the wood for the trees.

    https://www.excelforum.com/search.php?searchid=7177844

  89. #89
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Call in the Cavalry - 2017

    Quote Originally Posted by AliGW View Post
    Does anyone want to have a go at this? Looks deceptively easy, but I drew a blank - can't see the wood for the trees.

    https://www.excelforum.com/search.php?searchid=7177844
    Hi Ali,

    That one seems to have gone missing.

    Any ideas why?

  90. #90
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Call in the Cavalry - 2017


  91. #91
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Call in the Cavalry - 2017

    I think this one probably needs a VBA solution to rearrange the data. Can anyone help?

    https://www.excelforum.com/excel-pro...f-columns.html

  92. #92
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2017

    If this is doable by formula it is above my head.

    Maybe VBA?

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

  93. #93
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,422

    Re: Call in the Cavalry - 2017

    In Post #5 of this thread the OP would like to calculate the 95th percentile of the data (194000 rows) using the LOGINV function.
    The problem as far as I can tell is the presence of #NUM errors in the data, E15671:E19044 (among other places), however I may be missing something and feel that there may be others that are more well versed in statistical analysis that could offer help.

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

  94. #94
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2017

    Anyone familiar with finance?
    OP is struggling with an Averaging goal in a field I am not familiar with. I sense attempt to average averages. All I could solve was the array error. After that I don't even know what the questions are.

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

  95. #95
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Call in the Cavalry - 2017

    Hi, one of my colleague protected an excel file with password and forgot the password, can any one help in cracking the password.

  96. #96
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Call in the Cavalry - 2017

    What about rule 11 ?

    no file - no help
    (hope there is no personnal info or any sensitive data)
    Last edited by sandy666; 08-19-2017 at 01:37 AM.

  97. #97
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Call in the Cavalry - 2017

    Quote Originally Posted by nflsales View Post
    Hi, one of my colleague protected an excel file with password and forgot the password, can any one help in cracking the password.
    Siva, you should know better than to ask that here

  98. #98
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Call in the Cavalry - 2017

    Quote Originally Posted by FDibbins View Post
    Siva, you should know better than to ask that here
    I did not understand what you said

  99. #99
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Call in the Cavalry - 2017

    It is against forum rules to ask for password cracking

  100. #100
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Call in the Cavalry - 2017

    Siva - Your post does not comply with Rule 11 of our Forum RULES.

    Don't post questions regarding breaking or bypassing any security measure. Such posts will be deleted, and repeat offenders will be banned. This includes posting of links to sites that offer software, code or services to do this or posting of code to remove passwords

  101. #101
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Call in the Cavalry - 2017

    Quote Originally Posted by AliGW View Post
    Siva - Your post does not comply with Rule 11 of our Forum RULES.

    Don't post questions regarding breaking or bypassing any security measure. Such posts will be deleted, and repeat offenders will be banned. This includes posting of links to sites that offer software, code or services to do this or posting of code to remove passwords
    I am aware of that, that's why I asked here without attaching the file

  102. #102
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Call in the Cavalry - 2017

    file or no file, we do NOT allow discussions of password breaking, the rules are very clear on that

  103. #103
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Call in the Cavalry - 2017

    Quote Originally Posted by nflsales View Post
    Hi, one of my colleague protected an excel file with password and forgot the password, can any one help in cracking the password.
    and what we can say?

  104. #104
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Call in the Cavalry - 2017

    Quote Originally Posted by nflsales View Post
    I am aware of that, that's why I asked here without attaching the file
    The rule also clearly states:

    Don't post questions regarding breaking or bypassing any security measure.
    @ Sandy:

    and what we can say?
    Nothing, obviously! Any assistance offered would be in serious breach of the forum rules.

  105. #105
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Call in the Cavalry - 2017

    The question was rhetorical

  106. #106
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Call in the Cavalry - 2017

    It may have been, but some participants might not appreciate that subtlety.

  107. #107
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Call in the Cavalry - 2017

    Hm, and now what I can say ?

  108. #108
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2017

    This OP is trying to measure volatility in what I think are investments: https://www.excelforum.com/excel-for...ml#post4732117 I don't know how volatility is measured by investors (I suggested a couple of resources suggesting standard deviation to measure volatility), but I am not sure about the suitability of this measure for his data. Anyone here know about investing and can comment?

  109. #109
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2017

    https://www.excelforum.com/excel-cha...bar-chart.html

    I can confirm the behavior the OP describes in 2007. I don't know if it changes for other versions. Just wondering if anyone can either confirm the 100 label limit or not. Additional input would be welcome.

  110. #110
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Call in the Cavalry - 2017

    I added 500 labels and I can add more - bar chart (ex2k16-64)

  111. #111
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2017

    Interesting. The OP says that he is using 2016 as well. Possibly the OP is using a 32 bit version, and this limitation is due to a 32 bit version?

  112. #112
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Call in the Cavalry - 2017

    2013-2016
    Data series in one chart - 255
    Data points in a data series for 2-D charts - Limited by available memory
    Data points in a data series for 3-D charts - Limited by available memory
    Data points for all data series in one chart - Limited by available memory
    so if there is no limitation for points I can say - no limitation for labels

    maybe OP has 256 kb of RAM?

    2007
    Data points for all data series in one chart - 256,000

    summa summarum I added 1 000 labels for both series
    Attached Files Attached Files
    Last edited by sandy666; 08-30-2017 at 04:16 PM.

  113. #113
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2017

    I am aware of those limitations on #points/series and #points/chart, and have bumped up against them once. From my testing, it seems that this 100 labels per category axis is a separate limitation from the points/series limitation.

  114. #114
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Call in the Cavalry - 2017

    I don't have patience for more...
    156 series x 500 labels
    chart size: H:2500 x W:40 (cm) (ca. 984 x 16 in.)

    If you want to check this one - be my guest
    Attached Files Attached Files
    Last edited by sandy666; 08-30-2017 at 06:11 PM.

  115. #115
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2017

    You might revisit the thread. Aardigspook seems to have figured out what is going on with these category axis labels.

  116. #116
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Call in the Cavalry - 2017

    This confirms my thesis: OP should understand what he does
    500 axis labels
    156 series x 500 labels for values
    and it works.

    Like Aardigspook said there it depends on many factors, eg dates (horizontal - less, vertical - more) - Microsoft automation, size of chart... etc etc....

    All is well ends well
    Last edited by sandy666; 08-30-2017 at 06:44 PM.

  117. #117
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2017

    Anybody have some insight to offer here >> VBA and a Pivot Table

  118. #118
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Call in the Cavalry - 2017

    I'm stumped here. https://www.excelforum.com/excel-pro...worksheet.html

    When I run the Macro from Aug 28 sheet it errors out when it attempts to look at the Aug 21 sheet. Each sheet is identified in the code loop. Take a look at the whole issue as I have added a couple of lines of code that are not in the original.

    Thanks

    Alan

    EDIT: Solved.
    Last edited by alansidman; 09-06-2017 at 09:46 PM.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  119. #119
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Call in the Cavalry - 2017


  120. #120
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2017

    I'm sure I can come up with a solution for this (I even posted an outline of how I would envision doing it), but I am not yet ambitious enough to put all the effort into it. https://www.excelforum.com/excel-cha...ml#post4742713

    Perhaps one of you already has a procedure worked out for what the OP wants? Or maybe you know how to use some of Excel's built in database management tools to get this result? Or maybe one of you is more ambitious than I am? Or maybe we all wait to see how far the OP gets with the outline I gave him/her.

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

    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

  122. #122
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,422

    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

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

    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

  124. #124
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    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

  125. #125
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    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

  126. #126
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    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

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

    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?

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

    Re: Call in the Cavalry - 2017

    Anyone able to group rows including an empty row here?

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

    Re: Call in the Cavalry - 2017

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

  130. #130
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2017

    Anybody have an idea how to solve this in VBA?

  131. #131
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2017

    Could use some formula help here!

  132. #132
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    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

  133. #133
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2017

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

  134. #134
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    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

  135. #135
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    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; 10-18-2017 at 03:06 AM.

  136. #136
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Call in the Cavalry - 2017


  137. #137
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Call in the Cavalry - 2017

    Formulaic solution provided. OP now looking for VBA solution.

    https://www.excelforum.com/excel-for...ter-table.html

  138. #138
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Call in the Cavalry - 2017

    Once it became clear that VBA was neeeded, it was time for me to beat a hasty retreat...


    Any takers?

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

  139. #139
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Call in the Cavalry - 2017


  140. #140
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,422

    Re: Call in the Cavalry - 2017

    OP is looking for a formula to get a sum of values from multiple sheets and that works with the same functions (2016 version) that were used in the formula to get the sum of the values from each individual sheet. I attempted to help using functions available in the 2010 version, however that apparently isn't meeting the objective. You could probably skip down to post #13 in the thread to see specifically what the OP wants.
    https://www.excelforum.com/excel-gen...orksheets.html

  141. #141
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Call in the Cavalry - 2017

    I'm thoroughly confused. Hopefully, someone here can see through the maze.

    https://www.excelforum.com/excel-pro...one-sheet.html

  142. #142
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Call in the Cavalry - 2017

    Anybody want to submit to begging? At:

    https://www.excelforum.com/excel-pro...ta-filter.html

    I'm headed to bed as it is late.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  143. #143
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2017

    This one looks like it is headed into full blown dashboard development, which is way beyond my skill set: https://www.excelforum.com/excel-cha...-question.html I have pointed the OP to links discussing dashboard development, but perhaps those of you with more experience with that sort of thing may have additional or more specific ideas to contribute.

  144. #144
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Call in the Cavalry - 2017

    This is an interesting Windows Issue. Not an Excel Issue. Any takers.

    https://www.excelforum.com/excel-gen...e-taskbar.html

  145. #145
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2017

    Right click option 'Open a copy' suddenly vanished. Anybody know about this?

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

  146. #146
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Call in the Cavalry - 2017

    i can't get my head around a solution for this OP. https://www.excelforum.com/excel-pro...d-sorting.html

  147. #147
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2017

    I am thinking there are more than floating point issues here. Different sums sorted Ascending/Descending.

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

  148. #148
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Call in the Cavalry - 2017


  149. #149
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Call in the Cavalry - 2017

    Anybody else have an idea on this date issue?
    https://www.excelforum.com/excel-for...ml#post4795387

  150. #150
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Call in the Cavalry - 2017

    I give up... i have NO IDEA what is going on in his/her head....

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

  151. #151
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Call in the Cavalry - 2017

    I started this but now I'm backing out. Yes there is a (poor) language issue but he did provide sample answers in the cell comments. Not sure if he's asking to much of a formula though.
    https://www.excelforum.com/excel-for...hole-cell.html

  152. #152
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Call in the Cavalry - 2017

    Array issue
    https://www.excelforum.com/excel-pro...ect-field.html

    OP loops through array, the 8th column always comes up before the 9th column
    Please Login or Register  to view this content.

  153. #153
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2017

    Anybody have some suggestions on this filtering thread?

  154. #154
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Obtaining Hyperlink for file on DropBox

    Relating to this thread: https://www.excelforum.com/excel-pro...k-element.html

    Locally the (alias) path to a file saved to dropbox looks like this:
    C:\Users\kev\Dropbox\Penguins.jpg
    (this is known)

    The true path is:
    https://www.dropbox.com/s/txqf5cnhr7...guins.jpg?dl=0

    It's possible to get that path by
    - navigate to file in File explorer
    - right-click on the file
    - click option Copy Dropbox link
    - the value returned is the true path

    dropbox.jpg


    What I would like to be able to do is to write some VBA to lookup the alias and return the true path
    Does anyone know how to do that?

    thank you
    Last edited by AliGW; 12-11-2017 at 02:16 PM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  155. #155
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Call in the Cavalry - 2017

    I’m out of time. Some nice VBA loops to be added here:
    https://www.excelforum.com/excel-pro...positions.html

  156. #156
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2017

    This one has gone beyond the basic filtering that I readily know how to do. I'm sure if pressed I could figure out how to read the result of the filter into variables then put together the message box the OP wants, but I expect that many of you know better how to extract the information the OP wants and output it in a format more like what the OP wants. I also don't know and can't test what dflak's slicers can do in this regard.
    https://www.excelforum.com/excel-pro...-how-many.html

  157. #157
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,422

    Re: Call in the Cavalry - 2017

    According to the OP the data validation isn't working, although my tests are otherwise. The workbook has VBA components, so I am asking if a contributor with VBA experience to see if there is perhaps a conflict with the code and data validation. I believe that you can get the gist of the issue if you start with post #10.
    https://www.excelforum.com/excel-gen...ml#post4807697

  158. #158
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Call in the Cavalry - 2017

    This started out with the simple "are VBA macros and undo compatible", which they mostly aren't. https://www.excelforum.com/excel-pro...o-problem.html Though I did not say so in the thread, I suspect that someone with enough ambition could build their own undo handler to overcome this problem. Well, the OP found an example of an elaborate undo handler online and wants to adopt it into his/her project. The VBA is well beyond anything I can follow (with its use of classes and such). Anyone want to step in and help out here?

  159. #159
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2017

    I've never uploaded a *.zip file. This OP having upload problem.

    I am about to get an education.

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

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

    Re: Call in the Cavalry - 2017

    someone want to start off a 2018 thread?

  161. #161
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2017

    I've been waiting, too. Can just anyone start it?

  162. #162
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2017

    Yeah!

  163. #163
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2017

    OK. I've never posted 'Sticky' before. How's it done?

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

    Re: Call in the Cavalry - 2017

    think only mods can sticky it

  165. #165
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Call in the Cavalry - 2017

    I've created one, but can't make it sticky, so no, it would appear mods can't do that - sorry!

    EDIT: Done it!
    Last edited by AliGW; 01-03-2018 at 02:30 AM.

  166. #166
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Call in the Cavalry - 2017


  167. #167
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2017

    Sorry to have mislead you all

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Call in the Cavalry - 2016
    By JBeaucaire in forum The Water Cooler
    Replies: 147
    Last Post: 01-10-2017, 12:36 PM
  2. Call in the Cavalry - 2015
    By davesexcel in forum The Water Cooler
    Replies: 297
    Last Post: 01-13-2016, 06:50 PM
  3. [SOLVED] Call in the cavalry -- need help solving this thread-prior to 2013
    By teylyn in forum The Water Cooler
    Replies: 821
    Last Post: 01-06-2015, 08:01 PM
  4. Call in the Cavalry - 2013
    By FDibbins in forum The Water Cooler
    Replies: 457
    Last Post: 01-06-2015, 08:00 PM
  5. Call in the Cavalry - 2014
    By JBeaucaire in forum The Water Cooler
    Replies: 351
    Last Post: 01-06-2015, 07:56 PM
  6. Call in the Cavalry too long now so teach me something...
    By MarvinP in forum The Water Cooler
    Replies: 0
    Last Post: 12-26-2014, 04:04 PM

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