+ Reply to Thread
Results 1 to 164 of 164

Call in the Cavalry - 2019

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

    Call in the Cavalry - 2019

    Am I allowed to start a Call in the Cavalry thread for the new year? In the spirit of "it is easier to ask forgiveness rather than permission", I'm going to start a Call in the Cavalry thread for the new year.

    I do not have the business/financial know how to advise this OP on calculating interest on a payment plan. XIRR() seems like the obvious first choice, but I do not know if it is really applicable to the specific scenario being presented. Anyone with knowledge of such accounting issues contribute some financial expertise?

    Edit because, like an idiot, I failed to include the link to the thread in question: https://www.excelforum.com/office-36...ease-help.html
    Last edited by MrShorty; 01-03-2019 at 01:44 PM. Reason: add link to thread
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  2. #2
    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
    37,997

    Re: Call in the Cavalry - 2019

    Thread now stuck!

    You've not provided a link ...
    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.

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

    Re: Call in the Cavalry - 2019

    This is on a MAC, and the OP is having trouble array entering the formula: https://www.excelforum.com/excel-for...ml#post5037299 I think I have described the problem correctly, but perhaps someone who works on Macs can confirm and/or clarify how to array enter array formulas.

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

    Re: Call in the Cavalry - 2019

    A conditional formatting problem has me stumped.

    I almost never venture into these specialized areas of CF.
    OP wants to apply icon sets to two merged cells. Even after un-merging them I can't find a solution.
    Also CF rules for his criteria don't seem doable for icon sets. Hope I'm wrong.

    Conditional Formatting with a twist
    Dave

  5. #5
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,872

    Re: Call in the Cavalry - 2019

    Solver issue here:
    https://www.excelforum.com/excel-for...ml#post5041509

    I believe that I answered the original question but upon changing one of the cells that holds the constraint, a linearity error comes up.

    I don't understand the 3 different solver methods enough to say why. Evolutionary seems to work.

    Edit: I believe O.P. is happy with the result using the Evolutionary method.
    Last edited by 63falcondude; 01-10-2019 at 01:10 PM.

  6. #6
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,227

    Re: Call in the Cavalry - 2019

    Anybody understand what is going on here??
    https://www.excelforum.com/excel-pro...lumn-data.html

  7. #7
    Banned User!
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Call in the Cavalry - 2019

    Had what I thought was an easy follow up question until I realised I had misread it.

    https://www.excelforum.com/excel-for...-function.html

    OP is looking to identify the earliest possible combination of 3 distinct rows. The rows identified should be unique to each other, not the whole table (this was the bit I misunderstood).
    Follow up question starts at post #4, potential curveball identified in post #13.

  8. #8
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    6,681

    Re: Call in the Cavalry - 2019

    This person needs some help and the post doesn't seem to be drawing much attention AND, I am in the middle of reports at work so don't have the time.
    https://www.excelforum.com/excel-gen...and-group.html
    What has me a bit concerned is that he's PM'd me twice wanting to work only with me and asking about the business I am in, this might be completely innocuous but maybe not so you might want to be careful.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  9. #9
    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
    37,997

    Re: Call in the Cavalry - 2019

    If he PMs you again asking for help personally, please report the PM using the Report button and we shall deal with it, as it's against this forum's rules and code of conduct.

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

    Re: Call in the Cavalry - 2019

    Any VBA members feel like taking a look here please?
    https://www.excelforum.com/excel-pro...tra-error.html
    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

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

    Re: Call in the Cavalry - 2019

    OK.
    Got in over my head again.

    OP has a counting mission. I can not seem to interpret the criteria.


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

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

    Re: Call in the Cavalry - 2019


  13. #13
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    17,457

    Re: Call in the Cavalry - 2019

    Anybody up for this OP's situation? I originally thought that Power Query was the answer, but now I am not sure, perhaps a complex VBA? I am at a loss.

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

  14. #14
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    6,681

    Re: Call in the Cavalry - 2019

    checking to see if someone wants to look at this person's issue.
    https://www.excelforum.com/excel-for...ice-value.html
    he has PM'd me twice about helping him. I told him first time that I don't open macro enabled sheets often d/t work firewall issues.
    then he uploaded a .xls sheet and I told him I can't open those because I get an error notice if they are from outside sources, even if I try to save them first or change the extension.
    anyway, I have no idea why he came to me but hopefully someone can help him.

  15. #15
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    16,095

    Re: Call in the Cavalry - 2019

    Quote Originally Posted by Sambo kid View Post
    checking to see if someone wants to look at this person's issue.
    https://www.excelforum.com/excel-for...ice-value.html
    he has PM'd me twice about helping him. I told him first time that I don't open macro enabled sheets often d/t work firewall issues.
    then he uploaded a .xls sheet and I told him I can't open those because I get an error notice if they are from outside sources, even if I try to save them first or change the extension.
    anyway, I have no idea why he came to me but hopefully someone can help him.
    This guy PM'ed me too. People are not really supposed to do that.
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

  16. #16
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    6,681

    Re: Call in the Cavalry - 2019

    This guy PM'ed me too. People are not really supposed to do that.
    well then, it really wasn't for my expertise {what expertise} (you can't imagine how hard I'm laughing as I write that)!
    he quit PM'ing me so that is good. Don't think he's gotten any help yet.

    just checked and didn't realize there is a forum rule about that, good call to whomever thought about putting that in.

  17. #17
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    6,681

    Re: Call in the Cavalry - 2019

    Wow, I'm back again on this post.
    This time this person appears to need VBA to "move" what is in one cell in one area to another area when a date is entered.
    https://www.excelforum.com/excel-for...own-sheet.html
    thx.

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

    Re: Call in the Cavalry - 2019

    Anyone want to have a go at this? I am at a loss.

    https://www.excelforum.com/excel-pro...-returned.html
    Trevor Shuttleworth - Excel Aid

    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


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

    Re: Call in the Cavalry - 2019

    Anyone VBA literate? I am not.

    This OP has posted several self-attempts at solving their own problem. It is Xposted (now with link) and no response there yet.

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

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

    Re: Call in the Cavalry - 2019

    This appears to be a very specialized question.

    Can't tell if this is a math question or a finance formula question.

    ODDFPRICE function solved mathematically

  21. #21
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,227

    Re: Call in the Cavalry - 2019

    Can anybody help with this, I am not sure what the OP is asking

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

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

    Re: Call in the Cavalry - 2019

    Have a strange 1 here...
    https://www.excelforum.com/excel-new...rge-excel.html

    3 cells merged with text in them. Unmerging sees the test repeated in the 2nd row. Re-merge, change the text to something else, unmerge and the initial text still shows in the 2nd cell

  23. #23
    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
    37,997

    Re: Call in the Cavalry - 2019

    Anyone want to chip in here? I have to go. I am sure it does not require VBA, but the OP needs to give some clarification about what's going on.

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

    Thanks.

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

    Re: Call in the Cavalry - 2019

    OP is using the built in "box plot" chart available in newer versions, but claims that the box plot is calculating the wrong median. I cannot see the box plot in my older version of Excel. Can anyone with a newer version of Excel look at the sample and comment on the question? https://www.excelforum.com/excel-cha...ml#post5074706

  25. #25
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,227

    Re: Call in the Cavalry - 2019

    Quote Originally Posted by MrShorty View Post
    OP is using the built in "box plot" chart available in newer versions, but claims that the box plot is calculating the wrong median. I cannot see the box plot in my older version of Excel. Can anyone with a newer version of Excel look at the sample and comment on the question? https://www.excelforum.com/excel-cha...ml#post5074706
    Won't work for me, references errors. 365 at work.

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

    Re: Call in the Cavalry - 2019

    Anyone with a Mac help out here: https://www.excelforum.com/excel-pro...-on-a-mac.html

    I've tried to help with links to relevant sources but I cannot answer Mac related questions.


    Update: between us (me and the OP) we've muddled through and he has a solution based on code at Ron de Bruin's web site. Sadly, no takers from the community so maybe not many folk have Macs
    Last edited by TMS; 03-12-2019 at 06:52 PM.

  27. #27
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: Call in the Cavalry - 2019

    I hope I'm not breaking any rules by posting here, being relatively low on the forum hierarchy

    This person needs help with data form VBA (I think), which I am woefully unfamiliar with: https://www.excelforum.com/excel-for...t-comment.html

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

    Re: Call in the Cavalry - 2019

    I feel that this thread lends itself to a VBA solution.
    https://www.excelforum.com/excel-pro...ml#post5081172
    Seems to me that the code should start with cell AF1
    It should check the values of each cell in that column row by row until it finds one that has an absolute value that is larger than the tolerance +/- 0.005
    Once that value is found the code should delete the corresponding row's cells in columns G:AE (if AF is positive) or AG:DA (if AF is negative)
    The deletion should be such that all of the cells in the columns below the deleted cells move up as would happen if the cells were selected and 'Delete Cells' were chosen from the cells pane on the home tab
    The code would then need to copy the formula from cell AF1 down that column again, as the deletion will cause the cell in column AF of the row where the deletion takes place to produce a #REF! error
    The code would then start from AF1 again looking for a cell in the column that has an outside of tolerance value
    The code should terminate if either the cells to the left or right of an out of tolerance cell in column AF are blank or if it finds that there are no more out of tolerance values in column AF.
    Of course as many of you will already know I am VBA illiterate, so I may assume that VBA is able to do something that it can not.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

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

    Re: Call in the Cavalry - 2019

    I feel as if I have seen a number of threads regarding this topic and that they are solved using VBA.
    https://www.excelforum.com/excel-for...ml#post5081974
    The OP needs to import data from one of multiple workbooks into a workbook that is used to make a report of some of the data.
    Not sure that what I have done with formulas will be of any help, however the formulas in post #6 of the thread are the ones that work with the sample files provided by the OP.
    Reading post #7 in that thread, makes me feel as though VBA is a better approach.

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

    Re: Call in the Cavalry - 2019

    Rep for anyone that helps this guy out: https://www.excelforum.com/excel-pro...-recorder.html
    Entia non sunt multiplicanda sine necessitate

  31. #31
    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 - 2019

    I have to run out for the next few hours and struggling here on this VBA.

    I've read about how the mod in VBA is not like the worksheet function, so not sure how to apply multiple formats requested.
    HTH
    Regards, Jeff

  32. #32
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    16,095

    Re: Call in the Cavalry - 2019

    Quote Originally Posted by shg View Post
    Rep for anyone that helps this guy out: https://www.excelforum.com/excel-pro...-recorder.html
    I am working on this but he is asking for a lot for free.

  33. #33
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    12,701

    Re: Call in the Cavalry - 2019

    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

  34. #34
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    UK
    MS-Off Ver
    various
    Posts
    1,644

    Re: Call in the Cavalry - 2019

    I'm apparently missing a basic requirement here and so hoping someone can offer a fresh pespective?

    https://www.excelforum.com/excel-for...-function.html

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

    Re: Call in the Cavalry - 2019

    Is there a code (VBA) writer that could take a look at the following. OP wants some specific [conditional] formatting i.e. thick outline around certain cells and also have text horizontally centered across certain cells.
    https://www.excelforum.com/excel-pro...ml#post5091628

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

    Re: Call in the Cavalry - 2019

    This guy is trying to do some linear algebra involving quaternions and vectors and rotations/translations and other stuff that I know I could figure out with enough time and refreshing my memory. I seem to recall a couple of you who had done this before, so I was hoping you could chime in and help.
    https://www.excelforum.com/excel-gen...d-a-plane.html

  37. #37
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Rocester, New York, USA
    MS-Off Ver
    Excel 2007:10
    Posts
    1,984

    Re: Call in the Cavalry - 2019

    Struggling to come up with an answer to:
    https://www.excelforum.com/excel-gen...he-ribbon.html

    Where my answer isn't just "no, also, this is casually the worst idea I've ever seen on this board".
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  38. #38
    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 - 2019

    Anybody have a better formula solution here?

  39. #39
    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 - 2019

    I seem to be hitting an afternoon wall on formulas, but that is not all that unusual.

    I have this Sumifs working with multiple OR criteria in a Sumproduct, but now the OP has asked if the criteria value can be read from a range.

    I know the Sumproduct will allow the Sumif to use the OR, but can't seem to figure out the ranges. Any thoughts?

    https://www.excelforum.com/excel-for...-criteria.html

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

    Re: Call in the Cavalry - 2019

    I can't seem to convert Text to Values using a Power Query conversion. It is in the Debit and Credit columns of the Append table.

    What am I missing on this thread? I changed the source type on both so they might convert with no success. HELP!??

    https://www.excelforum.com/excel-for...t-working.html

    Love some help.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  41. #41
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,227

    Re: Call in the Cavalry - 2019

    Anybody want to tackle this? I'm focusing too much on the title and not the actual question.

    https://www.excelforum.com/excel-pro...rk-unlock.html

  42. #42
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: Call in the Cavalry - 2019

    Not sure how to accomplish this one.

    User is looking to match any maintenance item in a short list in one range to data in another sheet based on vehicle number, and return the date from the first match. This needs to be done for various maintenance periods (weekly, monthly, 6 months, etc.). There are items in each list that don't appear in the bigger data set, and items in the data set that don't appear in the lists. Example workbook with expected results is attached in the first post. Any assistance would be appreciated!
    If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.

    If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.

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

    Re: Call in the Cavalry - 2019

    I believe that the OP is looking to produce a permanent time stamp when a worksheet change event occurs in an corresponding cell. I know very little about VBA but have seen this kind of thing discussed as doable.
    https://www.excelforum.com/excel-gen...ml#post5102530

  44. #44
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    6,681

    Re: Call in the Cavalry - 2019

    anyone have anything for this long-time member? puts this in the cell =A5*1400*(9/7) and the formula bar shows it, then half the time it changes it to this...
    =A5*1400*(1.28571428571429)
    I can't recreate it and couldn't find anything relevant searching.
    https://www.excelforum.com/excel-gen...rmula-bar.html

  45. #45
    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 - 2019

    Anybody have some VBA thoughts to offer here?

  46. #46
    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
    37,997

    Re: Call in the Cavalry - 2019

    Anyone fancy a stab at this?

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

    It's not a regular list extraction - see the latest workbook sample attached to the post linked to.

    I'm experiencing brain freeze on this one!

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

    Re: Call in the Cavalry - 2019

    OP wants a calculated field to Pivot table to count 1s in two fields of the source data for each 'Name' in a third.
    OP is unable/unwilling to add helper column to source data.

    I am not sure this is doable with PT.

    Anyone?
    https://www.excelforum.com/excel-for...ml#post5111903

    Edit Forgot to mention OP profile is Excel 2010.
    Last edited by FlameRetired; 04-30-2019 at 05:22 PM.

  48. #48
    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 - 2019

    Can I get an assist here? I'm must be missing something. Thanks.

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

    Re: Call in the Cavalry - 2019

    This looks like an interesting Q for the VBA boffins here?
    https://www.excelforum.com/excel-gen...t-working.html

  50. #50
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    17,457

    Re: Call in the Cavalry - 2019

    Here is a challenge for you. I cannot get it to work for me. If you need to have the PQ results to get the file normalized, PM me and I will post it with the file for you.

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

  51. #51
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: Call in the Cavalry - 2019

    This is a weird one. OP is having trouble clicking on the proper cell, and Excel seems to be blurry when that occurs.

    https://www.excelforum.com/excel-gen...ll-i-want.html

  52. #52
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: Call in the Cavalry - 2019

    2nd one today. Guess my brain is on vacation This one needs either a math guru or an interpreter, not sure which.

    https://www.excelforum.com/excel-for...variables.html

  53. #53
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,872

    Re: Call in the Cavalry - 2019

    OP does not want to manually insert formulas so I believe this requires VBA:

    https://www.excelforum.com/excel-gen...ple-sheet.html

    Edit: It doesn't sound like they want a VBA solution either. Not sure any solution will be approved by them but I'll leave this here anyway.
    Last edited by 63falcondude; 05-18-2019 at 08:38 AM.

  54. #54
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,227

    Re: Call in the Cavalry - 2019

    Quote Originally Posted by 63falcondude View Post
    OP does not want to manually insert formulas so I believe this requires VBA:

    https://www.excelforum.com/excel-gen...ple-sheet.html

    Edit: It doesn't sound like they want a VBA solution either. Not sure any solution will be approved by them but I'll leave this here anyway.
    Could you suggest grouping the sheets, then entering the formula in the grouped sheets?

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

    Re: Call in the Cavalry - 2019

    I thought this thread would be about pivot tables and charts: https://www.excelforum.com/excel-cha...ive-chart.html However, the OP says that he/she is already pulling data from an Access database into Excel and wants to make it more "interactive". Since I know nothing about querying an access database from Excel, I'm calling in the Cavalry.

  56. #56
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Rocester, New York, USA
    MS-Off Ver
    Excel 2007:10
    Posts
    1,984

    Re: Call in the Cavalry - 2019

    I think that one will be really tough, in that it will be hard to give OP what they want, because they don't seem to even know what they want.

  57. #57
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    17,457

    Re: Call in the Cavalry - 2019

    https://www.excelforum.com/excel-for...worksheet.html

    OP looking for a Formula Based Solution. I have provided a workable VBA. This is beyond my Formula Skills.

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

    Re: Call in the Cavalry - 2019

    Anyone have a look at this please. I'm in hospital with only an iPad and I won't get near a computer until some time over the weekend. And, even then, Im not sure how well INDIRECT works with closed files.

    Have a cell that is linked to another workbook change

  59. #59
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    16,095

    Re: Call in the Cavalry - 2019

    Quote Originally Posted by TMS View Post
    Im not sure how well INDIRECT works with closed files.
    It doesn't. At all. I posted to the thread but just for background there are three possible solutions:

    1. Write VBA to open the file and read it instead of using INDIRECT
    2. Use an add-in that provides a UDF called INDIRECT.EXT, which uses VBA to open the file and read it
    3. Use VBA to write the formulas with direct external references


    Note that theme that VBA is required. Only the third solution avoids the overhead of opening files.

  60. #60
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    16,095

    Re: Call in the Cavalry - 2019

    Quote Originally Posted by TMS View Post
    I'm in hospital
    By the way, sorry to hear you are in hospital, cheering you on for a quick recovery and to get back home.

  61. #61
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    UK
    MS-Off Ver
    various
    Posts
    1,644

    Re: Call in the Cavalry - 2019


  62. #62
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    17,457

    Re: Call in the Cavalry - 2019

    I can't come up with a VBA solution here and it has been years since I played in DOS. If you can offer a suggestion.....

    I believe the answer should be in the .txt file but maybe you have a means to do it in Excel.

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

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

    Re: Call in the Cavalry - 2019

    @6sj:
    ... sorry to hear you are in hospital,...
    Thank you. I've had both knees replaced following several years of pain which was progressively getting worse. Now I have a different pain, but one which hopefully will ease over time. Thanks for your kind thoughts

  64. #64
    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 - 2019

    Richard might come up with the answer, but in the meantime, anybody with the formula chops want to tackle this?

  65. #65
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    17,457

    Re: Call in the Cavalry - 2019

    @TMS
    My wife just had her left knee done and is seven weeks post op. Having watched her for the past seven weeks, I know that your recovery will be quick and you will be amazed at how well you will be able to move. PT is a lot of work. Don't cheat on it as it is critical to your continued success. Good Luck with the new knees.

    Alan

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

    Re: Call in the Cavalry - 2019

    @Alan: thank you for your kind words and thoughts. I have a good start, can get both legs straight, and excellent bend on both sides. But I know I need to work on it!

  67. #67
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: Call in the Cavalry - 2019

    @TMS

    Happy to know you're doing better, and I hope your recovery is quick and successful

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

    Re: Call in the Cavalry - 2019

    @Melvosh: thank you, much appreciated

  69. #69
    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
    37,997

    Re: Call in the Cavalry - 2019

    Anyone any good with generating links to share files on Sharepoint via VBA? Could be a mail merge to E-mail.

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

  70. #70
    Valued Forum Contributor
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010
    Posts
    907

    Re: Call in the Cavalry - 2019

    Poker anyone?

    Here's a potentially interesting and novel problem for any poker players out there. It involves ordering poker hands in a very specific way. I got somewhat close but not close enough for the OP and I am unable to see any way forward either by formula or VBA.

    https://www.excelforum.com/excel-for...ulas-like.html

  71. #71
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    16,095

    Re: Call in the Cavalry - 2019

    Very large file (34MB) with data only, no formulas, CF rules removed, but Excel CPU% spikes into the 90s for no apparent reason when merely scrolling the screen.

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

  72. #72
    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
    37,997

    Re: Call in the Cavalry - 2019

    Anyone fancy having a go at understanding what the OP is trying to do here: https://www.excelforum.com/excel-for...setpoints.html

  73. #73
    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
    37,997

    Re: Call in the Cavalry - 2019


  74. #74
    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 - 2019

    I've tried do some researching on this, but I'm not winning. Any takers?

    I found this, but again, I must be using it wrong because it did not help. I managed to get the last row of a filtered set of data, but couldn't get the font to color.

  75. #75
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,244

    Re: Call in the Cavalry - 2019

    Anyone able to do a quick sanity test of this post, please: https://www.excelforum.com/excel-pro...ml#post5133205

    I can't recreate the OP's issue.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  76. #76
    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 - 2019

    Could somebody please sanity check this thread for me? Thanks.

  77. #77
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,227

    Re: Call in the Cavalry - 2019


  78. #78
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,244

    Re: Call in the Cavalry - 2019

    Quote Originally Posted by davesexcel View Post
    Worryingly, yes, I think I did...

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

    Re: Call in the Cavalry - 2019

    When importing data and refreshing wb OP wants a way to retain sheet formatting.

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

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

    Re: Call in the Cavalry - 2019

    I think the solutions I have provided can work, but I expect the OP would much rather have a nice array formula based solution: https://www.excelforum.com/excel-for...h-vlookup.html It involves the XIRR() function which does not like the usual array formula "replace the unwanted data with boolean/text and the main function just ignores the boolean/text" approaches. I seem to recall some of you having a different array formula technique that can completely remove the unwanted data from the input arrays. I expect that any of your solutions will be a lot easier if the OP will add the final valuation records to the XIRR data like I describe in the pivot table approach I outline in post #5.
    Last edited by MrShorty; 06-18-2019 at 02:15 PM.

  81. #81
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,227

    Re: Call in the Cavalry - 2019

    Quote Originally Posted by MrShorty View Post
    I think the solutions I have provided can work, but I expect the OP would much rather have a nice array formula based solution: https://support.office.com/en-us/art...b-a303ad9adc9d It involves the XIRR() function which does not like the usual array formula "replace the unwanted data with boolean/text and the main function just ignores the boolean/text" approaches. I seem to recall some of you having a different array formula technique that can completely remove the unwanted data from the input arrays. I expect that any of your solutions will be a lot easier if the OP will add the final valuation records to the XIRR data like I describe in the pivot table approach I outline in post #5.
    What is this referring to?

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

    Re: Call in the Cavalry - 2019

    Quote Originally Posted by davesexcel View Post
    What is this referring to?
    My mistake, wrong link. This thread: https://www.excelforum.com/excel-for...h-vlookup.html (correcting the previous post, too).

  83. #83
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    16,095

    Re: Call in the Cavalry - 2019

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

    User has set up a worksheet with a couple of pages of forms. There are ActiveX checkboxes that cause some rows immediately below to be populated or cleared. If the checkbox appears in the top 1" of the page in Page Layout View, the checkbox behaves erratically or doesn't work at all. The code is fine.

    This is either an Excel bug or a file corruption but I am not sure how to proceed.

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

    Re: Call in the Cavalry - 2019

    I have never encountered this before.

    =isodd(combin(25,10)) returns TRUE.

    combin(25,10) = 3,268,760

    Have tried CSE, coercion, Fx. Fx shows no different.

    Any ideas?


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

  85. #85
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    12,701

    Re: Call in the Cavalry - 2019

    @Flameretired Post 84
    Weird glitch. I even copied and pasted values of COMBIN(25,10) and ISODD(Cell1) still said TRUE.
    Then entered 3,268760 in another cell and that's FALSE
    then entered the equation Cell1 = Cell2 and that came out TRUE

  86. #86
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2016 primarily
    Posts
    4,231

    Re: Call in the Cavalry - 2019

    The value Excel is actually storing as the result is 3268759.9999999995. No idea why though.
    Rory
    Yea though I walk through the valley of the shadow of death, at least it's a change of scenery

  87. #87
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,799

    Re: Call in the Cavalry - 2019

    I'm guessing it's because Excel only stores up to 15 significant digits? Once you go past 17!, Excel starts replacing digits with zeros.

    In the case of 25!, the true value is 15,511,210,043,330,985,984,000,000, while in Excel it's 15,511,210,043,331,000,000,000,000. The denominator of the COMBIN function [(n-r)!*r!] also exceeds 15 significant digits at ~4.74e+18. It seems like a large number is being lopped off, but that portion is of little significance when you're looking at the numerator (~1.55e+25) and denominator (~4.75e+18).

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

    Re: Call in the Cavalry - 2019

    It seems strange (at least to me) that MS didn't do a final rounding step when it developed this function.

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

    Re: Call in the Cavalry - 2019

    I don't know how badly this needs the cavalry to come in, but I am kind of curious, too. The OP is asking about a new "spill" feature in the newest version of Excel that may be hidden behind a specific Office 365 subscription wall. I proposed a simple UDF to test with, and was just wondering if anyone with the proper 365 subscription could run the test and tell us if this spill range feature works for VBA UDFs: https://www.excelforum.com/excel-pro...ersection.html

  90. #90
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    12,701

    Re: Call in the Cavalry - 2019

    This is a supply chain type of question and I am not sure exactly what the OP is asking for.

    https://www.excelforum.com/excel-gen...d-on-fifo.html

    Thanks in advance

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

    Re: Call in the Cavalry - 2019

    Trying to help the OP use Power Query to append tables. I feel as if some of the steps that I took to append the tables could be consolidated using the Power Query Advanced Editor and that some of the contributors here could be of more help in that regard than I.
    Note that the file's summary sheet lists 87 tables that will need to be appended although the sample file only contains two.
    https://www.excelforum.com/commercia...ml#post5146002

    Edit: This is a commercial services thread.
    Update: The OP has appreciated the thread.
    Last edited by JeteMc; 06-30-2019 at 09:38 PM. Reason: Added edit and update

  92. #92
    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
    37,997

    Re: Call in the Cavalry - 2019

    FAO: Olly

    Could do with your PQ expertise/advice here: https://www.excelforum.com/excel-pro...ml#post5146460

  93. #93
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,244

    Re: Call in the Cavalry - 2019

    Quote Originally Posted by AliGW View Post
    FAO: Olly

    Could do with your PQ expertise/advice here: https://www.excelforum.com/excel-pro...ml#post5146460
    Done

  94. #94
    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 - 2019

    Could use some help here?

  95. #95
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,872

    Re: Call in the Cavalry - 2019

    I could keep going here but I feel like I am wasting my time.

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

    Re: Call in the Cavalry - 2019

    The linked thread is a "populate a calendar from a list" type request, and I imagine that a calendar similar to the one the OP wants already exists.
    https://www.excelforum.com/excel-for...ml#post5150708

  97. #97
    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
    37,997

    Re: Call in the Cavalry - 2019

    Data layout disaster - anyone fancy helping this member to get his data into a usable and unbreakable format? I'm off out, so can't help just now.

    https://www.excelforum.com/excel-for...eferences.html

  98. #98
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,872

    Re: Call in the Cavalry - 2019

    Could use help here.

    OP wants to combine two workbooks with different structures based on two columns.

    I suspect that this can be done with Power Query but it's beyond my know how.

    https://www.excelforum.com/excel-for...column-id.html

  99. #99
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,261

    Re: Call in the Cavalry - 2019

    My colleague with MAC laptop is on vacation and I can't test. Can someone with more MAC knowledge or access to MAC help OP?
    https://www.excelforum.com/excel-pro...cript-mac.html
    Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.
    ― Robert A. Heinlein

  100. #100
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 2010
    Posts
    1,220

    Re: Call in the Cavalry - 2019

    Copied to the thread the code he was using for zillow and he has now provided the API ID to run it,
    but not sure if I can take it from here and don't want to leave everyone else thinking I'm working on it and him with no answer - (if someone else would otherwise have answered it)

    https://www.excelforum.com/excel-pro...illow-api.html
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  101. #101
    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
    37,997

    Re: Call in the Cavalry - 2019

    I am pretty sure the OP's maths is wrong here, but I am not confident enough in my own assumptions to help him. Any maths experts want to help out?

    https://www.excelforum.com/excel-gen...in-2019-a.html

  102. #102
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    16,095

    Re: Call in the Cavalry - 2019

    VBA implementation for CDO for sending email

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

    I started to help based on the code he showed that uses Outlook, but then he says that they decided to use CDO. It's not hard but I have not done this and don't have time to figure it out from scratch. If someone else is already comfortable with coding for CDO sendmail in VBA please feel free to step in.

  103. #103
    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
    37,997

    Re: Call in the Cavalry - 2019

    The OP of this VBA thread is not sure why they arent getting any responses. Could a VBA expert take a look, please?

    https://www.excelforum.com/excel-pro...-docments.html

  104. #104
    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 - 2019

    Not sure I'm understanding this. Any helpers!

  105. #105
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,244

    Re: Call in the Cavalry - 2019

    Quote Originally Posted by jeffreybrown View Post
    Not sure I'm understanding this. Any helpers!
    The lovely joys of PowerPivot and DAX

  106. #106
    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
    37,997

    Re: Call in the Cavalry - 2019

    Potential for a PQ solution here, but I've run out of time. Anyone?

    https://www.excelforum.com/excel-gen...ells-h-mm.html

  107. #107
    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 - 2019

    Thanks Olly for the help. Yes, this is an area I have not even waded into.

  108. #108
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    6,681

    Re: Call in the Cavalry - 2019

    I think this person needs a VBA solution to their issue (and if so maybe the post moved there too).
    https://www.excelforum.com/excel-for...-invoices.html
    I'll be interested in seeing if anyone has a formula solution for the OP.

  109. #109
    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
    37,997

    Re: Call in the Cavalry - 2019

    I've hit a brick wall with this one: https://www.excelforum.com/excel-for...-criteria.html

    The OP has rejected the solution that gave wthe icon sets they wanted as too fiddly. They now want a cell fill solution that does not involve helper columns. I'm not managing to make the lookup needed in the CF rule work. Anyone able to step in?

  110. #110
    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
    37,997

    Re: Call in the Cavalry - 2019

    VBA query: something to do with checkboxes controlling macros. The OP is understandably perplexed at getting no response: it looks as if the detail is there. Can a VBA expert take a look, please?

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

  111. #111
    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 - 2019

    Unfortunately I just got called away, but at the same time, can't see this one.

    I believe other parts of the spreadsheet are missing, plus cell F14 points to B18 which is really nothing. Thanks.

  112. #112
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    17,457

    Re: Call in the Cavalry - 2019

    In this thread, look at posts 7, 8 and 9. https://www.excelforum.com/excel-pro...me-folder.html

    Firstly, this is a Power Query Issue Consolidation of Excel Files issue. If you filter the appended file (Book8) for the indicated spreadsheet, you will see that the columns C & D are imported as nulls. Yet they contain data and if you Load this file on its own and not part of a consolidation, it will populate those columns. I am baffled by this. Do you see anything in the original file that will cause this aberration.

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

    Re: Call in the Cavalry - 2019

    Anyone feel like taking at look at this 1?
    https://www.excelforum.com/excel-pro...ml#post5169679

    "add-existing-image-from-excel-sheet-to-the-body-of-an-email"

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

    Re: Call in the Cavalry - 2019

    It is not yet clear, but this one is probably going to involve the newer waterfall chart type in the newer versions of Excel that I don't have access to. Can anyone familiar with the waterfall charts in the newer versions comment on what is possible and not possible in these charts?
    https://www.excelforum.com/excel-cha...ml#post5172714

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

    Re: Call in the Cavalry - 2019

    All I am managing to do is confuse myself here.

    OP prefers formula solution to a summary table.

    They have consented to helper column(s) in the source data sheets and eliminated the merged cells from source.

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

  116. #116
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    6,681

    Re: Call in the Cavalry - 2019

    I got them a "partial" answer but I think they need to restructure their data which was my last recommendation...
    https://www.excelforum.com/excel-gen...rect-data.html
    the problem is that the formula needs to index 8 columns to the right when they come up with a different date selection.
    it appears to me to be a three way match for 17 weeks, then jumps to the right for the next set of dates and positions for the next 17 weeks.
    I wonder if it needs a macro solution, it is already a macro enabled workbook.

    I'll be interested to see what someone else comes up with.

  117. #117
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    17,457

    Re: Call in the Cavalry - 2019

    https://www.excelforum.com/excel-gen...-w-commas.html

    Custom Sorting -- Gave a solution to the OP but he is interested in something less cumbersome. I am empty on this!

  118. #118
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily NL, sometimes UK
    MS-Off Ver
    2010
    Posts
    2,270

    Re: Call in the Cavalry - 2019

    Strange behaviour here: http://www.excelforum.com/excel-gene...down-list.html
    Right-clicking a cell and choosing 'Pick from drop-down list' enables an entry in a cell which should not be allowed according to the Data Validation rule for that cell. I found a sort-of workaround, but it's not great. Has anyone seen this before / have a better solution?
    Regards,
    Aardigspook

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

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

    Re: Call in the Cavalry - 2019

    I believe that this thread has gone beyond the capabilities of formulas. Any VBA contributors want to take a look at the last couple of posts by the OP and see if code could be written to accomplish the task?
    https://www.excelforum.com/excel-gen...ml#post5183056

  120. #120
    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
    37,997

    Re: Call in the Cavalry - 2019

    Anyone interested in taking up either of these two threads? I don't have enough time today to pursue them, and don't want the OPs to feel marooned!

    To do with job scheduling and calculation working hours for a job spanning two or more days: https://www.excelforum.com/excel-gen...ng-issues.html

    Working out most recent five match outcomes in a football league: https://www.excelforum.com/excel-for...lude-form.html

    Thanks to anyone who can step in.

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

    Re: Call in the Cavalry - 2019

    OP would like to have formulas to automate tracking of withdrawals from retirement portfolio while preserving the formulas and set up that are in place in the file attached to post #1.
    I had tried to steer OP towards some formulas that I felt were more efficient, however...
    https://www.excelforum.com/excel-gen...ml#post5184192

  122. #122
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,227

    Re: Call in the Cavalry - 2019

    Anybody have time to fix the autofilter macro?

    https://www.excelforum.com/excel-pro...ter-range.html

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

    Re: Call in the Cavalry - 2019

    I can't really help with this one, since my version of Excel does not support slicers. https://www.excelforum.com/excel-pro...ing-dates.html

  124. #124
    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 - 2019

    I don't think I have the skills to really get involved here, but if somebody wanted to take a run at it.

    I think the problem stems from what started out as a formula to capture unique numbers (dates) is now bleeding over into VBA producing text results.

    https://www.excelforum.com/excel-for...mn-values.html

    https://www.excelforum.com/excel-pro...-2-sheets.html

  125. #125
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,872

    Re: Call in the Cavalry - 2019

    My brain isn't working this morning.

    Does someone want to take over? Thinking it'll come down to a nested IF formula.

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

    I recreated the sample (picture) and desired results as well.
    Attached Files Attached Files

  126. #126
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,227

    Re: Call in the Cavalry - 2019

    Can someone thing of a formula solution to this problem?

    https://www.excelforum.com/excel-gen...d-columns.html

  127. #127
    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 - 2019

    Not sure I see this one as achievable in the way the OP wants. Any ideas?

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

  128. #128
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    24,318

    Re: Call in the Cavalry - 2019

    I am beginning to lose the will to live here:

    https://www.excelforum.com/excel-for...-required.html

    Any takers??
    Glenn



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

    Re: Call in the Cavalry - 2019

    Anyone have a look at this ...

    https://www.excelforum.com/excel-pro...or-method.html

    We've narrowed down the cause of the problem but Im not strong on combo boxes and their properties.

  130. #130
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    6,681

    Re: Call in the Cavalry - 2019

    I can't help this person. Every time I open his workbook the links cause the data to go away and the formula I offered works in his workbook as I can see it but apparently doesn't work for the OP.
    https://www.excelforum.com/excel-gen...numbering.html
    The cells it references contain an array formula to an external workbook.

  131. #131
    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 - 2019

    Any suggestions here that may have been overlooked?

  132. #132
    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 - 2019

    Macro wise, this is out of my league. Any want to help?

  133. #133
    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 - 2019

    Here's another one I got tangled in and don't see an easy solution.

    https://www.excelforum.com/excel-for...reference.html
    Last edited by jeffreybrown; 09-28-2019 at 01:06 PM. Reason: Inserted link to make more visible!

  134. #134
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    17,457

    Re: Call in the Cavalry - 2019

    I can't see anything wrong here, but the OP insists that it does give him the results he needs. If you can help.....

    https://www.excelforum.com/excel-for...her-sheet.html

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

    Re: Call in the Cavalry - 2019

    dflak, I don't know if you have seen this post about a 9 box performance matrix however the set up looks almost exactly like one that you gave as a solution in post #2 of this thread
    I do not know VBA so I can not explain to the OP how it would work, or even know if the concept you proposed could be used in this instance, however I thought that you might want to take a look.

  136. #136
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    17,457

    Re: Call in the Cavalry - 2019

    Look at this link. The OP needs a consolidation of information in a range. The issue is that the number of sheets to consolidate for the range varies amongst a number of files. I suspect it is a case of determining a valid array which I cannot determine.

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

  137. #137
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    24,318

    Re: Call in the Cavalry - 2019

    Ahem.... I didn't notice this was a Google sheets Q..

    What's a Google sheet???????*


    Any takers?

    https://www.excelforum.com/for-other...ml#post5206293

    * Only joking... I just never inhaled near one...

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

    Re: Call in the Cavalry - 2019

    This user wants to draw with drawing shape objects in VBA-- something I have no idea exactly how to do. https://www.excelforum.com/excel-pro...ml#post5206507

  139. #139
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    UK
    MS-Off Ver
    various
    Posts
    1,644

    Re: Call in the Cavalry - 2019

    https://www.excelforum.com/excel-cha...g-columns.html

    OP wants to apply a calculated item on a Pivot which relies on Grouping (unrelated Date field); I don't think it can be done, but hoping someone else may know better...

  140. #140
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,244

    Re: Call in the Cavalry - 2019

    Quote Originally Posted by XLent View Post
    I don't think it can be done, but hoping someone else may know better...
    Power Pivot to the rescue...

  141. #141
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    UK
    MS-Off Ver
    various
    Posts
    1,644

    Re: Call in the Cavalry - 2019

    Thanks Olly - tried to add rep but, apparently, I need to share around first...
    {tried to yesterday re: CUBEVALUE suggestion, in fact}

  142. #142
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,872

    Re: Call in the Cavalry - 2019

    Trying to use a SUM(COUNTIF( ... , {} , ... , {} )) style formula that isn't working as expected.

    O.P. came up with a solution using SUMPRODUCT but I would like to know why the SUM COUNTIF formula was not calculating as we expect.

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

    See post #6 for smaller sample to test on.

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

    Re: Call in the Cavalry - 2019

    I suspect this can be done formula wise but will require a different layout / lookup table(s).

    I am stumped on how to approach that. https://www.excelforum.com/excel-gen...onditions.html

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

    Re: Call in the Cavalry - 2019

    Some of you guys are better at writing formulas to a spreadsheet with VBA. In this one, we are writing a SUMIFS() to the spreadsheet, and I think we are having trouble with the quotation marks that are part of the formula string: https://www.excelforum.com/excel-pro...ml#post5212094

  145. #145
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    16,095

    Re: Call in the Cavalry - 2019

    Migrate Excel UserForm to Access Database Form

    This is a Commercial Services thread.

    This user has an Excel file with a UserForm that does several updates to worksheets. OP wanted this ported to Access so that the code would still update the Excel file. I imported the UserForm and rewrote the code so that Access could execute the code to update the Excel file. I used late binding. However, the user did not want it just ported as a VBA UserForm, user wants a new Access form created to emulate the same functionality. I do not know how to link actions on an Access form to VBA and it's not worth the time it would take me to learn it just for this one question. OP has valued thread at 50 points.

    The Access data is almost 20MB so cannot be attached to the thread. I received the file and send a solution via email with the OP.
    Last edited by 6StringJazzer; 10-21-2019 at 11:37 AM.

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

    Re: Call in the Cavalry - 2019

    OP put this on "hold" for about a year and are now back.

    I am useless in VBA. All I could do confirm the errors they were getting. https://www.excelforum.com/excel-gen...eekends-2.html

  147. #147
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    UK
    MS-Off Ver
    various
    Posts
    1,644

    Re: Call in the Cavalry - 2019

    "known" issue re: reading filter criteria on a date field, where default grouping behaviour enabled:

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

    does anyone happen to know of workarounds aside:

    a) disabling the grouping and/or using the date filter option (in preference to grouping), or
    b) reading saved XML {per a link provide in above thread}

  148. #148
    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
    37,997

    Re: Call in the Cavalry - 2019

    Calling PQ Experts (Olly???)

    This seems ripe for direct access to data on a website: https://www.excelforum.com/excel-for...to-a-cell.html

    The OP is doing comparisons of players - I have been able to directly access some of the data he wants, but not all. Maybe someone knows how to move forward with this?

  149. #149
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,244

    Re: Call in the Cavalry - 2019

    Quote Originally Posted by AliGW View Post
    Maybe someone knows how to move forward with this?
    That was fun

  150. #150
    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
    37,997

    Re: Call in the Cavalry - 2019

    Aha - my call to arms was answered! Thanks, Olly - going to have a look now, with great interest.

  151. #151
    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
    37,997

    Re: Call in the Cavalry - 2019

    I seem to be experiencing complete brain fog with this one: https://www.excelforum.com/excel-gen...-on-range.html

    Help!

  152. #152
    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
    37,997

    Re: Call in the Cavalry - 2019

    VBA - adding prefixes to folder names based on a lookup list in Excel - can anyone help?

    https://www.excelforum.com/excel-pro...ist-excel.html

  153. #153
    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
    37,997

    Re: Call in the Cavalry - 2019

    Anyone fancy a stab at this? Non-VBA solution requested. I was trying to do it with PQ, but hit a brick wall.

    https://www.excelforum.com/excel-gen...s-headers.html

  154. #154
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    17,457

    Re: Call in the Cavalry - 2019

    Any takers for an AverageIfs need. No Pivot Tables! No VBA! Formula only! https://www.excelforum.com/excel-for...statement.html

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

    Re: Call in the Cavalry - 2019

    Never seen this before.

    Upon downloading the attachment here there are no buttons to enable editing and the screen is blue ... as if the sheet is hidden. It's not.

  156. #156
    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
    37,997

    Re: Call in the Cavalry - 2019

    Can anyone help with a FREQUENCY question with dates? I have to go offline very shortly.

    https://www.excelforum.com/excel-for...early-etc.html

  157. #157
    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 - 2019

    Can I ask for a VBA smart person to help here?

  158. #158
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,227

    Re: Call in the Cavalry - 2019

    Can somebody look into this lookup function, it worked originally, now seems to only work for about 7 rows.
    https://www.excelforum.com/excel-for...onditions.html

  159. #159
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,227

    Re: Call in the Cavalry - 2019

    ANybody know how to save an email?

    https://www.excelforum.com/excel-pro...to-folder.html

  160. #160
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    24,318

    Re: Call in the Cavalry - 2019

    This one is doing my head in. I can get it working for one machine... but it falls over when I try and add in another. It's probably a horrible SUM/SUMPRODUCT + MMULT concoction.

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

  161. #161
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,507

    Re: Call in the Cavalry - 2019

    Hi Glenn,

    it didn't involve those functions at all !!

    Pete

  162. #162
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    24,318

    Re: Call in the Cavalry - 2019

    It might, Pete. He said he wanted the formula dynamic to cope with any number of machines.

  163. #163
    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 - 2019

    This seems to be out of my league. The OP wants to return a unique list, but with two variables. The two part I don't know how. Any takers?

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

  164. #164
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,507

    Re: Call in the Cavalry - 2019

    Hi Jeff,

    I used a helper in Sheet1 to select the records, then a straightforward INDEX/MATCH to retrieve them.

    Pete

+ 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 - 2018
    By AliGW in forum The Water Cooler
    Replies: 152
    Last Post: 01-10-2019, 12:06 PM
  2. Call in the Cavalry - 2017
    By JBeaucaire in forum The Water Cooler
    Replies: 166
    Last Post: 01-03-2018, 12:58 PM
  3. Call in the Cavalry - 2016
    By JBeaucaire in forum The Water Cooler
    Replies: 147
    Last Post: 01-10-2017, 12:36 PM
  4. Call in the Cavalry - 2015
    By davesexcel in forum The Water Cooler
    Replies: 297
    Last Post: 01-13-2016, 06:50 PM
  5. Call in the Cavalry - 2013
    By FDibbins in forum The Water Cooler
    Replies: 457
    Last Post: 01-06-2015, 08:00 PM
  6. Call in the Cavalry - 2014
    By JBeaucaire in forum The Water Cooler
    Replies: 351
    Last Post: 01-06-2015, 07:56 PM
  7. 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