+ Reply to Thread
Results 1 to 52 of 52

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 Subscription Insider (Windows 11)
    Posts
    52,098

    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,700

    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 Subscription Insider (Windows 11)
    Posts
    52,098

    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,577

    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,577

    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,947

    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
    20,434

    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
    12,218

    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
    8,020

    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 Subscription Insider (Windows 11)
    Posts
    52,098

    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
    8,020

    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 Subscription Insider (Windows 11)
    Posts
    52,098

    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,608

    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,577

    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
    8,020

    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,608

    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,577

    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,577

    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,608

    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 Subscription Insider (Windows 11)
    Posts
    52,098

    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,577

    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
    8,020

    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 Subscription Insider (Windows 11)
    Posts
    52,098

    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,608

    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
    20,434

    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
    8,020

    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 Subscription Insider (Windows 11)
    Posts
    52,098

    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,684

    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,684

    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 Subscription Insider (Windows 11)
    Posts
    52,098

    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.

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

    Re: Call in the Cavalry - 2021

    https://www.excelforum.com/excel-for...n-dataset.html
    Post #8
    I solved the initial question but my solution to the follow up (post 8) would be very long. I think one of you formula geniuses can come up with something shorter.

  32. #32
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11)
    Posts
    52,098

    Re: Call in the Cavalry - 2021

    Anyone able to finish this one, please?

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

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

    Re: Call in the Cavalry - 2021

    I resorted to redimensioning a range with this one.

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

    I can't help but believe someone adept at using FILTERXML could pull off a better solution. This function is a complete mystery to me. Every time I try to understand it I swear I go "snow blind". LOL

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

    Re: Call in the Cavalry - 2021

    Need a VBA person, not my forte.

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

    Looking to color specific cells either at opening or at push of a button. Thanks in advance.

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

    Re: Call in the Cavalry - 2021


  36. #36
    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
    33,816

    LOTUS 123 conversion to Excel

    Anyone on here familiar with Lotus 123 files, functions and formulae?

    In this thread, there is a requirement to convert a couple of files from Lotus 123 to Excel. i can get them into Excel, via LibreOffice, but there are formulae and functions that are not familar to me. They produce #NAME? errors.

    Can anyone shed any light, convert them
    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


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

    Re: Call in the Cavalry - 2021

    https://www.excelforum.com/excel-for...ml#post5549919
    OP would like to know if, when a new row is inserted into an Excel table, VBA could copy formulas into the new row and then sort the table based on those formulas.

  38. #38
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11)
    Posts
    52,098

    Re: Call in the Cavalry - 2021

    Is anyone able to cut to the chase in this thread? Maybe I am being exceptionally dense this morning, but I cannot work out exactly what the OP is asking for.

    https://www.excelforum.com/excel-for...audit-due.html

  39. #39
    Valued Forum Contributor
    Join Date
    01-05-2013
    Location
    Singapore/China
    MS-Off Ver
    H&B 2016
    Posts
    1,138

    Re: Call in the Cavalry - 2021

    Need help from forum experts.. please take a look at the thread below:
    https://www.excelforum.com/excel-gen...ml#post5552183

    Thank you.

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

    Re: Call in the Cavalry - 2021

    This OP wants to Custom format for days hours, minutes and seconds. Trouble is sometimes the desired days output is larger than the 31 day limit.

    I have not been able to come up with anything that does not create a concatenated string ...

    Any ideas?

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

    Re: Call in the Cavalry - 2021

    The OP here https://www.excelforum.com/excel-cha...ml#post5555282 is requesting detailed instructions for formatting a data series. Since I am not familiar with the O365 UI, I am wondering if it would be helpful for someone more familiar with the O365 UI could help with the details of finding the options for formatting a data series in a chart.

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

    Re: Call in the Cavalry - 2021

    The OP here https://www.excelforum.com/excel-gen...ml#post5555444 says he wants to use checkboxes or similar to determine what points should be shown in a chart. Since I don't use those kinds of "controls", I cannot help much.

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

    Re: Call in the Cavalry - 2021

    OP could use some VBA help here please...
    https://www.excelforum.com/excel-new...ml#post5556749
    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

  44. #44
    Valued Forum Contributor
    Join Date
    01-05-2013
    Location
    Singapore/China
    MS-Off Ver
    H&B 2016
    Posts
    1,138

    Re: Call in the Cavalry - 2021

    This is an interesting problem.. can the experts take a look please, thank you:

    https://www.excelforum.com/non-engli...r-valores.html

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

    Re: Call in the Cavalry - 2021

    OP states their original post disappeared and they are having difficulty uploading. I can see his post fine and his file downloads at my end.

    He may just need assurance from others (and maybe a trained eye to critique his request since I don't do VBA).

  46. #46
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11)
    Posts
    52,098

    Re: Call in the Cavalry - 2021

    Dave - he says he would prefer formulae, NOT VBA!

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

    Re: Call in the Cavalry - 2021

    Thanks Ali. I must have missed that.

  48. #48
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,434

    Re: Call in the Cavalry - 2021

    OP needs a tweak to his VBA code.

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

  49. #49
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,434

    Re: Call in the Cavalry - 2021

    This Power Query issue has me stumped. Need someone with really good Mcode experience to work on this. I cannot get it.

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

  50. #50
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    2,803

    Re: Call in the Cavalry - 2021

    There is a piece of code that runs fine and loops through several files, but on occasions fails to execute saving a particular file. It is beyond my skills to help further as vba is not really my thing. does anyone else have some suggestions
    https://www.excelforum.com/excel-gen...utomation.html

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

    Re: Call in the Cavalry - 2021

    This thread probably needs VBA expertise of which I have none.
    The OP would like to put 60k names into selectable sized groups based on one, two or three criteria (i.e. City and/or Subject and/or Priority).
    https://www.excelforum.com/excel-pro...ml#post5580234

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

    Re: Call in the Cavalry - 2021

    This OP is getting duplicate counts where he says they aren't. I suspect it has to do with "**" embedded in the literal strings that COUNTIFS is treating as wildcards. I seem to recall there is a way to deal with these but do not recall what it is beyond requiring leading "~".

    Any ideas? https://www.excelforum.com/excel-for...ml#post5581229

+ 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