+ Reply to Thread
Results 1 to 28 of 28

Call in the Cavalry - 2022

  1. #1
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,494

    Call in the Cavalry - 2022

    Post here for 2022.
    Ali


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


    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.

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

    Re: Call in the Cavalry - 2022

    Thanks Ali
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    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
    36,269

    Re: Call in the Cavalry - 2022

    Happy New Ca!ll-in-the-Cavalry

    Please could someone have a look at this thread for me. https://www.excelforum.com/excel-pro...ing-early.html

    Note: I have added a blank header row to the data as the code starts at row 2.

    To test, I am copying the Original Data to the Cleaned up Data sheet and repeating.

    Basically, there are two simple loops. The last row is determined initially and equals 18. The first loop checks all the cells in the range A2:A18. The second loop SHOULD check all the cells tn the range C2:C18. However, it simply OMITS cell C3. The Debug shows cells C2, C4, C5, ... C18.

    I have no idea why this is happening.
    Attached Files Attached Files
    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


  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,057

    Re: Call in the Cavalry - 2022

    OP is using the 2010 version of Excel and would like to "lock columns that are automated" (see post #22).
    File is in post #19.
    https://www.excelforum.com/excel-new...ml#post5620696
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

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

    Re: Call in the Cavalry - 2022

    Anyone feel like taking a stab at this 1?
    https://www.excelforum.com/excel-pro...med-range.html

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,494

    Re: Call in the Cavalry - 2022

    Does anyone have time to have a stab at this one?

    https://www.excelforum.com/excel-gen...or-events.html

    WARNING: Nightmare data!

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,494

    Re: Call in the Cavalry - 2022


  8. #8
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,057

    Re: Call in the Cavalry - 2022

    DAX formula question has gotten too complicated for me.

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

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

    Re: Call in the Cavalry - 2022

    OK this 1 has me completely puzzled, any1 else feel like a head-scratch?
    https://www.excelforum.com/excel-gen...ml#post5627316

  10. #10
    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
    36,269

    Re: Call in the Cavalry - 2022

    Probably should have just left this one alone.

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

    Anyone know anything about logical regression testing and standardising data?

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

    Re: Call in the Cavalry - 2022

    I feel like this thread is turning into a lookup table/lookup function kind of thing that I am just not equipped to address: https://www.excelforum.com/excel-gen...ml#post5640244 I don't know whether to focus on getting a different "pivot/lookup" table to make the lookup function easier, or whether there is a better way to search the data for the 2 parameters the OP wants to search.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

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

    Re: Call in the Cavalry - 2022

    Anyone have a suggestion here
    HTH
    Regards, Jeff

  13. #13
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,494

    Re: Call in the Cavalry - 2022

    Can anyone help with this?

    https://www.excelforum.com/excel-gen...with-time.html

    It's a time difference issue where the hours between 1800 and 0600 need to be ignored. I am sure there is a much simpler solution, and there are now extra requirements, so it has got away from me.

  14. #14
    Valued Forum Contributor
    Join Date
    07-23-2013
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    683

    Re: Call in the Cavalry - 2022

    That certainly took longer than I thought it would (especially when even more extra requirements appeared), but got there in the end.

  15. #15
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,057

    Re: Call in the Cavalry - 2022

    Hoping that someone can improve on the power pivot measures I provided in post #4: https://www.excelforum.com/excel-cha...ml#post5647298

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

    Re: Call in the Cavalry - 2022

    This is looking like a substantial project, and will probably venture into areas that I have no expertise in. I have asked the OP to focus on a specific part of the project to start, but if others can watch and contribute where they can: https://www.excelforum.com/excel-gen...j-program.html

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

    Re: Call in the Cavalry - 2022

    Someone wanting to create/format a chart using VBA. I don't use VBA for charting, so I'm expecting that someone else will be better able to help with the VBA portion of this thread: https://www.excelforum.com/excel-cha...bar-graph.html

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

    Re: Call in the Cavalry - 2022

    Someone here is having trouble calling Solver from VBA. I suspect a Reference error, but cannot verify (either a bad sample file or something in the OP's file that is not compatible with my older version of Excel). Can anyone with 2019 verify my results? https://www.excelforum.com/excel-pro...ss-solver.html

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

    Re: Call in the Cavalry - 2022

    My older version of Excel does not support data labels from cells. Can someone with 2013 or later look at this and see if you can understand what is happening with the OP's data labels.
    https://www.excelforum.com/excel-cha...ml#post5674493

  20. #20
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,494

    Re: Call in the Cavalry - 2022

    I am having a mental block here, I think! Can anyone assist?

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

  21. #21
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,494

    Re: Call in the Cavalry - 2022

    Does anyone fancy picking this one up?

    https://www.excelforum.com/excel-gen...-the-week.html

    Thanks.

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

    Re: Call in the Cavalry - 2022

    The OP here (https://www.excelforum.com/excel-pro...rpolation.html ) wants to switch the current calculations (a double/bilinear interpolation) to a VBA UDF. Some of you will be better than me at this, so I'm requesting some back up on this one.

  23. #23
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,494

    Re: Call in the Cavalry - 2022

    Anyone fancy taking on this SUMPRODUCT problem?

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

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

    Re: Call in the Cavalry - 2022

    For those with the "newest" version of Excel, can you help explain the process of importing a text file here: https://www.excelforum.com/excel-gen...ml#post5681293 My old version (2007) has no trouble importing text files with different date formats using the old text import wizard, but I get the impression that the mechanics have changed dramatically in the newest version as Power Query gets more integrated into Excel.

  25. #25
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,477

    Re: Call in the Cavalry - 2022

    Any one got any thoughts on how to "validate" a street address in Excel

    https://www.excelforum.com/excel-for...ngle-cell.html
    Alan


    Have you debugged your code?
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  26. #26
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,494

    Re: Call in the Cavalry - 2022

    Anyone fancy trying to come up with a SPILL array formula for this one?

    https://www.excelforum.com/excel-gen...scription.html

  27. #27
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,494

    Re: Call in the Cavalry - 2022

    This has morphed into a VBA query. OP wants a cell to contain a look up but also be able to write back to the lookup list.

    https://www.excelforum.com/excel-pro...other-cel.html

  28. #28
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,562

    Re: Call in the Cavalry - 2022

    I can't figure out what this person is looking for, I tried a couple times to get them to clarify it a bit more but
    perhaps someone can give it a look and see what new eyes can bring to the problem.

    https://www.excelforum.com/excel-gen...condition.html
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ 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 - 2021
    By AliGW in forum The Water Cooler
    Replies: 59
    Last Post: 01-07-2022, 12:58 PM
  2. Call in the Cavalry - 2020
    By JBeaucaire in forum The Water Cooler
    Replies: 97
    Last Post: 12-15-2020, 04:27 PM
  3. Call in the Cavalry - 2019
    By MrShorty in forum The Water Cooler
    Replies: 163
    Last Post: 12-30-2019, 02:39 PM
  4. Call in the Cavalry - 2017
    By JBeaucaire in forum The Water Cooler
    Replies: 166
    Last Post: 01-03-2018, 12:58 PM
  5. Call in the Cavalry - 2015
    By davesexcel in forum The Water Cooler
    Replies: 297
    Last Post: 01-13-2016, 06:50 PM
  6. Call in the Cavalry - 2013
    By FDibbins in forum The Water Cooler
    Replies: 457
    Last Post: 01-06-2015, 08:00 PM
  7. Call in the Cavalry - 2014
    By JBeaucaire in forum The Water Cooler
    Replies: 351
    Last Post: 01-06-2015, 07:56 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