+ Reply to Thread
Results 1 to 30 of 30

Call in the Cavalry - 2021

  1. #1
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,489

    Call in the Cavalry - 2021

    Here it is!!!

    Let's hope that 2021 is a better year for all of us.
    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.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,057

    Re: Call in the Cavalry - 2021

    Thanks for setting this up so promptly, Ali.

    Pete

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,489

    Re: Call in the Cavalry - 2021

    No problem.

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

    Re: Call in the Cavalry - 2021

    Forcing Sum of percents to equal original total

    https://www.excelforum.com/excel-for...ent-split.html
    ChemistB
    My 2

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

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

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

    Re: Call in the Cavalry - 2021

    Confused:
    I think the OP wants a very simple thing. I am just not understanding what it is. LOL, is it me or are we missing information?

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

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

    Re: Call in the Cavalry - 2021

    Suggestions for scheduled macro to run.

    https://www.excelforum.com/excel-pro...in-column.html

  7. #7
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,671

    Re: Call in the Cavalry - 2021

    Here is a PQ and Hyperlinks situation. I can't get it to work. Its in CS, so there is a couple $$ available to the finder.

    https://www.excelforum.com/commercia...ml#post5475284

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

    Re: Call in the Cavalry - 2021

    I can't tell how much of this is just me and how much is gibberish.

    https://www.excelforum.com/excel-gen...ml#post5481108
    Last edited by FlameRetired; 03-02-2021 at 06:50 PM.
    Dave

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

    Re: Call in the Cavalry - 2021

    Mark it to get future notice.

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,489

    Re: Call in the Cavalry - 2021

    Mark what, Bebo?

  11. #11
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    7,841

    Re: Call in the Cavalry - 2021

    Quote Originally Posted by AliGW View Post
    Mark what, Bebo?
    Then "User CP" to tell me if there is new port in this thread
    Attached Images Attached Images

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,489

    Re: Call in the Cavalry - 2021

    You can use Subscribe to This Thread under Thread Tools - no need to actually post to a thread to get notifications.

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

    Re: Call in the Cavalry - 2021

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

    This discussion has gone from basic "how do I create a scatter chart in Excel" into something more about immunology/molecular biology/biochemistry, none of which are my field of expertise. I seem to recall that one or two of you here may have experience in these fields, and, hopefully, may be better able to provide information about how the experiment should go and how the data from the experiments would be analyzed.

    I think I could handle the spreadsheet programming side of this question, but I just cannot quite understand what the raw data from the experiment should look like, so I cannot really advise on how to go from running the experiment to know what data the experiment should generate. If any of those fields seem familiar to you, have a look and see if you can help better than I can.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

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

    Re: Call in the Cavalry - 2021

    The boolean logic here got too complex for my brain today.

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

  15. #15
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    7,841

    Re: Call in the Cavalry - 2021

    Need help from VBA expert!
    OP want to read cell colour .
    https://www.excelforum.com/excel-for...ext-color.html

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

    Re: Call in the Cavalry - 2021

    I'm not that familiar with pivot tables. This user has combined a couple of different sources into a pivot table and is having trouble getting something from the resulting pivot chart: https://www.excelforum.com/excel-cha...ml#post5492114
    Perhaps someone can jump in and help.

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

    Re: Conditional Formatting Request

    I don't think this is possible without VBA but feel free to prove me wrong. Looking for a conditional conditional formatting.

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

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

    Re: Call in the Cavalry - 2021

    Anybody? Maybe it should be moved to the VBA forum?
    https://www.excelforum.com/excel-for...formattng.html

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

    Re: Call in the Cavalry - 2021

    This user is bringing data into Excel with Power Query, and then needs a simple subtraction/duration calculation performed. I was wondering if it would be easier to perform the subtraction/duration calculation as part of the Power Query import process rather than do it with spreadsheet formulas after the import: https://www.excelforum.com/excel-gen...ml#post5497027

  20. #20
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,489

    Re: Call in the Cavalry - 2021

    I can't get my head around what the OP is asking for here: https://www.excelforum.com/excel-gen...g-pincode.html

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

    OP's workbook is crashing

    OP's spreadsheet is crashing after implementing an Arrayed Formula (Excel 2007). There's not a lot of data so I don't think it should crash. Can someone with IT knowledge take a look at this?

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

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

    Re: Call in the Cavalry - 2021

    Really need VBA helpers. It can be solved quickly with formula, but the OP hope to get VBA solution for large database.

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

  23. #23
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,489

    Re: Call in the Cavalry - 2021

    Need VBA here, now, it seems (the OP has just mentioned that he wants a VBA solution!!!

    I still have NO CLUE what the process is that he wants to automate - can anyone work out what washing and sweeping are???

    https://www.excelforum.com/excel-pro...from-file.html

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

    Re: Call in the Cavalry - 2021

    A FILTER() function that sometimes returns a Spill error that I cannot debug: https://www.excelforum.com/excel-gen...ml#post5502595

  25. #25
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,671

    Re: Call in the Cavalry - 2021

    This OP has presented an issue that is above my ability to solve. VBA is the means as it involves .interior.colorindex over four different ranges that need to be compiled.

    https://www.excelforum.com/excel-pro...ls-pt-2-a.html

  26. #26
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    7,841

    Re: Call in the Cavalry - 2021

    This link is my own question: How to merge cells without losing data? In file attached, cells inside merged range seem not to be deleted!

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

  27. #27
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,489

    Re: Call in the Cavalry - 2021

    Bebo - this is NOT what this thread is for. You posted your query only three minutes before posting here. This thread is for when someone has worked to try to help an OP over a protracted period of time, but hit a roadblock and is calling for someone else to have a look.

    Please don't misuse this thread again.
    Last edited by AliGW; 05-05-2021 at 12:56 AM.

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

    Re: Call in the Cavalry - 2021

    Could someone whom is familiar with dynamic array formulas please take a look at the question about whether or not the formulas in post #6 will automatically fill down (I think that is called spill).
    https://www.excelforum.com/excel-for...ml#post5514814
    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
    12,082

    Re: Call in the Cavalry - 2021

    Could someone whom is familiar with horizontal scroll bars take a look at the file in post #7 of https://www.excelforum.com/excel-gen...ml#post5517645
    The scroll bar is positioned in cells J1:AD1 and should cause the sheet to reposition by the weeks shown in row 9.
    I have attempted to address the rest of the request.

  30. #30
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,489

    Re: Call in the Cavalry - 2021

    Could someone chip in here: https://www.excelforum.com/excel-for...ment-date.html

    I'm swamped at work at the moment - no time to follow it up. Thanks.

+ 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. [SOLVED] Formulating 1/1/2021-1/2/2021, 1/3/2021-1/9/2021 etc through one row.
    By jbposey86 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-24-2020, 08:27 PM
  2. Call in the Cavalry - 2019
    By MrShorty in forum The Water Cooler
    Replies: 163
    Last Post: 12-30-2019, 02:39 PM
  3. Call in the Cavalry - 2018
    By AliGW in forum The Water Cooler
    Replies: 152
    Last Post: 01-10-2019, 12:06 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 - 2016
    By JBeaucaire in forum The Water Cooler
    Replies: 147
    Last Post: 01-10-2017, 12:36 PM
  6. Call in the Cavalry - 2015
    By davesexcel in forum The Water Cooler
    Replies: 297
    Last Post: 01-13-2016, 06:50 PM
  7. Call in the Cavalry - 2013
    By FDibbins in forum The Water Cooler
    Replies: 457
    Last Post: 01-06-2015, 08:00 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