+ Reply to Thread
Results 1 to 20 of 20

Call in the Cavalry 2024

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

    Call in the Cavalry 2024

    Happy New Year, everyone!
    Ali


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

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

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

    Re: Call in the Cavalry 2023

    Anybody fancy a run at this!

    https://www.excelforum.com/excel-for...-register.html
    HTH
    Regards, Jeff

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

    Re: Call in the Cavalry 2024

    I know how to build the chart in this thread, but the OP also wants help designing the overall spreadsheet. Where and how to best input the raw data, how to have the tables at the top, and have the chart as desired. It isn't the kind of spreadsheet programming I do, so I'm not very good at it. My current thought is that, if one built a good "database" for the raw data, the "reporting" tables and the chart table could be extracted from the raw data with filters/pivots, but, as noted, those aren't my strengths.

    https://www.excelforum.com/excel-cha...bar-chart.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

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

    Re: Call in the Cavalry 2024

    Can someone help with some coding here please?
    https://www.excelforum.com/excel-gen...ml#post5912471
    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

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

    Re: Call in the Cavalry 2024

    Is this even possible with a CF formula? Or will it require VBA?

    https://www.excelforum.com/excel-for...mic-range.html

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

    Re: Call in the Cavalry 2024

    The request in post #7 of this thread may be possible using either 365 function based formulas or VBA. I don't know enough about either to help.
    https://www.excelforum.com/excel-for...ml#post5915436
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

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

    Re: Call in the Cavalry 2024

    Glenn




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

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

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

    Re: Call in the Cavalry 2024

    This member isn't getting any traction. Can anyone assist?

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

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

    Re: Call in the Cavalry 2024

    I'm confident this formula can simplified using a LET() or LAMBDA() or similar function, but lack support in my older version. Can anyone step in with a solution: https://www.excelforum.com/excel-for...ml#post5925327

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

    Re: Call in the Cavalry 2024

    Can anyone else have a look at the chart in the attached file? The OP has a picture showing the chart truncating the line in the chart at 9 Feb, but, when I open the file, the line extends to 22 Feb. I can't debug the problem if I can't see the problem, and I cannot seem to guess what would cause Excel to fail to draw the line connecting the last few data points in the chart. I'm wondering if it is a problem specific to the OP's version or installation of Excel, and hope that one of you can recreate the problem and debug it.

    https://www.excelforum.com/excel-cha...ml#post5926569

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

    Re: Call in the Cavalry 2024

    Anyone got any thoughts, ideas, suggestions, comments on this thread:

    Fragile Excel
    Trevor Shuttleworth - Retired Excel/VBA Consultant

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

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


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

    Re: Call in the Cavalry 2024

    This one is more a maths/stats problem: https://www.excelforum.com/excel-for...el-format.html

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

    Re: Call in the Cavalry 2024


  14. #14
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Call in the Cavalry 2024

    Can someone look at this... https://www.excelforum.com/excel-for...ml#post5932741
    they cannot get my answer to work but it works for me in my sample I attached. It could be a translation issue though I tried translating into Norwegian.
    It doesn't error out.
    they want an active hyper link that they click on to take them to today's date in col C. Is it a Google sheets issue?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

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

    Re: Call in the Cavalry 2024

    This one is more of a maths/stats question than an Excel question. Any takers?

    https://www.excelforum.com/excel-gen...r-of-88-a.html

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

    Re: Call in the Cavalry 2024

    This ine needs a 2021 solution (no 365 available): https://www.excelforum.com/excel-for...-products.html

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

    Re: Call in the Cavalry 2024

    Second half of this needs solving (Excel 2019 or VBA): https://www.excelforum.com/excel-for...f-entries.html

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

    Re: Call in the Cavalry 2024


  19. #19
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    1,987

    Re: Call in the Cavalry 2024

    Some strange ribbon and instance creation behaviour. Perhaps someone has a suggestion.

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

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

    Re: Call in the Cavalry 2024

    I got very close with this one, but fell at the final hurdle - any takers?

    https://www.excelforum.com/excel-for...and-below.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 2 users browsing this thread. (0 members and 2 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 - 2018
    By AliGW in forum The Water Cooler
    Replies: 152
    Last Post: 01-10-2019, 12:06 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