Closed Thread
Results 1 to 82 of 82

Call in the Cavalry 2023

  1. #1
    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
    43,896

    Call in the Cavalry 2023

    As mentioned by FlameRetired
    Last edited by AliGW; 01-01-2024 at 03:19 AM.
    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

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    re: Call in the Cavalry 2023

    Thank you again Glenn.
    Dave

  3. #3
    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
    43,896

    Re: Call in the Cavalry 2023

    Anyone still using Excel 2007???


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

  4. #4
    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,093

    Re: Call in the Cavalry 2023

    Anyone fancy having a look at this … manage filter cell from another sheet

    I thought a sample file might clarify the requirement but, for me, it didn't.

    It's been up over a week with lots of views and now the OP is getting himself in trouble by PMing people asking them to look at the thread.

    Thanks … and Happy New Year to everyone if it's not too late to say that.
    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


  5. #5
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,957

    Re: Call in the Cavalry 2023

    Happy New year 2023! And, Gong Xi Fa Cai to those celebrating the Chinese New Year!

    Could anyone take a look at this thread https://www.excelforum.com/excel-for...ted-items.html please? I have no idea how to proceed.

    Thank you.

  6. #6
    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

    Using VBA, I could probably easily take care of the deleting of dups, but the combining results from column L, I'm not sure.

    Any takers?

    https://www.excelforum.com/excel-pro...uplicated.html
    HTH
    Regards, Jeff

  7. #7
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,957

    Re: Call in the Cavalry 2023

    Can someone please help to look at this thread: https://www.excelforum.com/excel-for...ml#post5781784.

    Thank you.

  8. #8
    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,093

    Re: Call in the Cavalry 2023

    Anyone care to take a look at this. The OP wants what it says on the tin, to combine 3 VBA functions.

    Combining 3 VBA functions into a single VBA sub

    I don't have time to unravel it and wondered if anyone else was up to the challenge.

    Thanks.

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

    Re: Call in the Cavalry 2023

    I feel like Power Query would be the easiest choice for extracting the data from the two tables and combining into one for the stacked bar chart the OP is requesting here: https://www.excelforum.com/excel-pro...ml#post5790746 I don't know PQ, so cannot help. As near as I can tell, the goal is to put together a table where we have start time and and end time/durations for select "line names" so that we can then build the stacked bar/Gantt chart that visualizes the operation.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

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

    Re: Call in the Cavalry 2023

    Another database management thread that goes way beyond my skill set: https://www.excelforum.com/excel-pro...ml#post5791957

    The OP is getting a daily text file (with data every half hour of the day). I have recommended the possibility of using these text files to build a solid database that they could then use to perform all kinds of daily, weekly, monthly analyses. Can any of you database + Power Query experts step in and help with the things the OP can/should do to build a good database from these daily text files and later add new days to the database?

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

    Re: Call in the Cavalry 2023

    Could someone using the 365 edition take a look at this thread pertaining to a new feature (to me) of Autocompletion from a drop-down list?
    https://www.excelforum.com/excel-for...ml#post5799150
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  12. #12
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    365 32bit Win
    Posts
    1,811

    Re: Call in the Cavalry 2023

    Anyone willing to take a look at this thread?


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

    Seems simple enough but I might have overlooked something as my results are not the same as the OPs

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

    Re: Call in the Cavalry 2023

    Three of us have looked at this and not been able to "solve" it.
    I have been having trouble deciphering the OP's notes and since I believe they are still looking for a solution I thought I'd post it here...
    https://www.excelforum.com/excel-for...f-b-and-d.html
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  14. #14
    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,093

    Re: Call in the Cavalry 2023 - FAO Glenn Kennedy maybe?

    FAO Glenn Kennedy maybe?

    How can I convert this google sheet formula to excel?

    The OP is using a FILTER function in Google Sheets but wants to convert to Excel 2016. I have seen clever stuff done with FILTERXML but it is not a strong point for me.


    Thoughts and ideas would be appreciated from anyone/everyone.

  15. #15
    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

    I see no solution here outside of VBA. I guess the OP is wanting all the hundreds of charts because of some type of report.

    Any ideas?

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

  16. #16
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry 2023

    I do not understand what the OP is getting at. Can anyone discern and solve?

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

  17. #17
    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,917

    Re: Call in the Cavalry 2023

    why are all these posts blank???...


    OK weird, now they are no longer blank
    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

  18. #18
    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,917

    Re: Call in the Cavalry 2023

    I have a strange 1 here...
    https://www.excelforum.com/outlook-f...ml#post5811211

    MATCH() should work, but it doesnt. Read my comments in post #4 there

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

    Re: Call in the Cavalry 2023

    Quote Originally Posted by FDibbins View Post
    why are all these posts blank???...


    OK weird, now they are no longer blank
    I went through something similar a couple weeks ago. In my case, I found that if I navigated to any thread as a result of a search using the site's search engine (other than the "what's new" search), the thread content was blank. If I navigated through the "what's new" search or by manually finding the thread in the forum lists, then the thread content was visible.

  20. #20
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry 2023

    I went through the same thing @ 2 weeks ago. I hit F5 and it cleared up, but I had to do it with each thread. It eventually cleared up (after I posted about it).

  21. #21
    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

    I'm way out of my league here. Any ideas?

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

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

    Re: Call in the Cavalry 2023

    The OP would like to format data points in a pivot chart based on value i.e., <3% green and >=3% red. My feeling is that it might be possible if a regular chart is produced from the pivot table, however I am ignorant of how that works.
    https://www.excelforum.com/excel-cha...ml#post5812397

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

    Re: Call in the Cavalry 2023

    Could someone with Word VBA experience have a look at this please …
    Adding Non-breaking space to both ends of a text selection

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

    Re: Call in the Cavalry 2023

    This looks like it will become a database design project. https://www.excelforum.com/excel-gen...c-diagram.html I'm not skilled at database design, but I figure there are several of you who know how to put together databases in Excel that could help with moving data from an input tab into a database and then build some simple count/summary data off of that database.

  25. #25
    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
    79,400

    Re: Call in the Cavalry 2023

    The OP here wants a spill formula to populate dates in a column, but I just don't get what the formula he currently has is supposed to be doing. Anyone fancy taking a look?

    https://www.excelforum.com/excel-gen...r-workday.html
    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.

  26. #26
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry 2023

    Wants to compare words in a single cell string against another such cell. (Excel 2007)
    OP has added several conditions adhoc. Grrr. This may be beyond my skill set. Maybe VBA is a better route. I cannot tell right now but will continue to explore.

    Meanwhile any "takers"?

  27. #27
    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
    79,400

    Re: Call in the Cavalry 2023

    Print area issue - no idea what else to suggest given the dearth of detail. Anyone?

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

  28. #28
    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
    79,400

    Re: Call in the Cavalry 2023

    I can't see the wood for the trees here: https://www.excelforum.com/excel-for...variables.html

    Looks like it should be easy, but I cannot understand exactly how he wants it to work. I understand the arithmetic, just not the layout.

  29. #29
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Call in the Cavalry 2023

    VBA date copy/paste problem

    CS post says that when he runs the VBA code, it copies dates from one place to another incorrectly. On examination of his sample file, some dates are pasted as date values and some are pasted as text. The ones pasted as text are correct but the ones pasted as values reverse the day and month.

    I used his file and ran his code and it worked perfectly.

    I suspect the issue is somehow related to the regional settings. If someone uses European date formats and would like to try this the thread is worth 20 points and is not locked.

    https://www.excelforum.com/commercia...sometimes.html
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  30. #30
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,161

    Re: Call in the Cavalry 2023

    It appears that the source data is in text format. Moreover, the source data is in US format, and trying to copy it is done on a computer with UK settings (or vice versa).
    Excel is a very greedy tool when it comes to date conversions. It "likes" to convert to date anything that resembles it. I suspect that after copying, the "dates" in text format are the ones that Excel did not convert because the number of days (in US format in the second place) is greater than 12. For example, the "date" in US 07/15/2022 was not able to convert, while the "date" US 07/04/2022 is able to convert to UK format 04/07/2022.

    If the source data were written in date format, the copying would probably run without any problems, because numbers are copied. In the case of date-like texts, some may convert to dates and some will remain texts. It seems that in the case of texts, we should first convert the data to dates using, for example, DATE, RIGHT, MID, LEFT formulas, and only then copy to the destination.

    But this is just my guess, because I don't have access to the sample file.

    Artik
    Last edited by Artik; 05-01-2023 at 09:26 PM.

  31. #31
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Call in the Cavalry 2023

    That was my conclusion looking at his screenshot but the actual file did not look like the screenshot. Someone in another forum provided a solution but I tried it and it's just plain wrong.

    I told him I would just rewrite the code if he could explain what it's supposed to do.

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

    Re: Call in the Cavalry 2023

    https://www.excelforum.com/excel-gen...ml#post5826036
    The pivot table shown in the file attached to post #29 should be sorted ascending by the Days2 column.
    As can be seen that isn't the case and I can not understand why.
    The pivot table's source data is on the Tournament sheet.
    Perhaps someone with more knowledge of pivot tables could resolve the issue.

  33. #33
    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
    79,400

    Re: Call in the Cavalry 2023

    Any help with this Google Sheets conditional formatting query? I cannot get my head around what the OP is trying to achieve exactly.

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

  34. #34
    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
    79,400

    Re: Call in the Cavalry 2023

    I spent all day on and off yesterday and another hour or so this morning solving the OP's first challenge, and now he has introduced another level of complexity. I don't have that amount of time for head-scratching today, so if anyone else wants to have a go, it's here: https://www.excelforum.com/excel-for...-criteria.html

    If it's of help, I can probably explain the logic of the bit I solved more clearly than the OP did, so if you need that, just shout.

  35. #35
    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
    43,896

    Re: Call in the Cavalry 2023

    Ali, Thank you but NO thank you. I looked at yesterday's post and hadn't even the vaguest notion of what was wanted! Kudos for sticking at it.. I'm on the road today and will resist the temptation to have a go.

  36. #36
    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
    79,400

    Re: Call in the Cavalry 2023

    The logic was nowhere near as obtuse in the end as he made it - it took longer to get my head around that than the solution, but the final sticking point was curious, and I learnt something about using VSTACK along the way that I hadn't anticipated!

    I bet you won't be able to resist it ...

    And I know there's at least one other here who will probably be working on a much simpler 2D spill array, so let's watch this space!!!

  37. #37
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Call in the Cavalry 2023

    I am happy to help people get over a sticking point when they're stuck but when the time needed is measured in hours it sounds more like a consulting project for free. I tend to avoid those.

  38. #38
    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
    79,400

    Re: Call in the Cavalry 2023

    So do I, but my puzzle-mad brain got the better of me and I was determined to work out what was going on. It is not as complicated as it looks, but it took ages for the penny to drop for me.

  39. #39
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Call in the Cavalry 2023

    I asked OP for a workbook with sample data. OP posted workbook with sampledata that looks alright I guess.
    Only problem is, I can't see the pattern...

    https://www.excelforum.com/excel-pro...5-numbers.html
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  40. #40
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Call in the Cavalry 2023

    Quote Originally Posted by Jacc View Post
    I asked OP for a workbook with sample data. OP posted workbook with sampledata that looks alright I guess.
    Only problem is, I can't see the pattern...
    I have seen many posts by this user and they are all poorly explained. His trouble with English is only part of the problem; he just doesn't explain things well. He seems to be obsessed with some sort of analysis to predict lottery winning numbers, which is always a fool's errand. But I posted asking some detailed questions to see if we can at least understand the question.

  41. #41
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Call in the Cavalry 2023

    Quote Originally Posted by 6StringJazzer View Post
    I have seen many posts by this user and they are all poorly explained. His trouble with English is only part of the problem; he just doesn't explain things well. He seems to be obsessed with some sort of analysis to predict lottery winning numbers, which is always a fool's errand. But I posted asking some detailed questions to see if we can at least understand the question.

    Oh. The sad reality.

  42. #42
    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
    79,400

    Re: Call in the Cavalry 2023

    This one requires someone who understands and is proficient in calculating effective interest over multiple investments (not just how to do it in Excel): https://www.excelforum.com/excel-gen...vestments.html

    Any takers?

  43. #43
    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
    79,400

    Re: Call in the Cavalry 2023

    Can someone have a look at this one: https://www.excelforum.com/excel-for...-an-issue.html

    I thought I had cracked it, but apparently not. The OP keeps repeating the rules and I'm clearly missing something, but they are reluctant to provide more than one row of sample data at a time.

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

    Re: Call in the Cavalry 2023

    This request seems to be beyond my abilities. At the moment, my mind is not focused enough to address this request. I would appreciate it if someone could step in to help. Thank you.
    https://www.excelforum.com/excel-for...ml#post5840318
    Quang PT

  45. #45
    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
    79,400

    Re: Call in the Cavalry 2023

    An interesting PQ one here that requires refinement. I have managed to get so far, but there'll be a better way to generate the columns I am sure. Added into the mix now is the desire to fill down text, but not numbers, in columns with a mixed economy. I could do it, but it would be horrendously clunky!

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

  46. #46
    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
    79,400

    Re: Call in the Cavalry 2023

    This seems to be a maths question: https://www.excelforum.com/excel-gen...tribution.html

  47. #47
    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
    79,400

    Re: Call in the Cavalry 2023

    One for PowerQuery experts:

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

    The OP has .txt files in a folder, some of which use a comma delimiter and some a semi-colon. Wants to know how to automate importing them at once with PQ.

  48. #48
    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
    79,400

    Re: Call in the Cavalry 2023

    I am struggling to establish how parameters for a dataset will be fed into a formula in this thread: https://www.excelforum.com/excel-gen...culations.html

    Not only has the OP accused me of being impolite (I have not), she is now getting very impatient and I am losing the will to persist in my questioning. Can someone else get the relevant information out of her or, better still, work it all out from what she's already said? Thanks!
    Last edited by AliGW; 08-01-2023 at 09:55 AM. Reason: Typo fixed.

  49. #49
    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,093

    Re: Call in the Cavalry 2023

    Not only has the OP accused me of being impolite (I have not), ...
    No, you weren't. I don't think I'll be stepping in there

  50. #50
    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
    79,400

    Re: Call in the Cavalry 2023

    Thanks! She's apologised now.

  51. #51
    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,093

    Re: Call in the Cavalry 2023

    Still, I can find enough to do without this particular challenge

  52. #52
    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
    79,400

    Re: Call in the Cavalry 2023

    It's been solved, so no need to worry (not by me).

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

    Re: Call in the Cavalry 2023

    This looks to me like a FILTER() or equivalent function nested inside of another statistical function. Or maybe a pivot table with an appropriate calculated field, or some such solution, that is not within my wheelhouse: https://www.excelforum.com/excel-for...nded-date.html

  54. #54
    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,093

    Re: Call in the Cavalry 2023

    @MrShorty: options suggested.

  55. #55
    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
    79,400

    Re: Call in the Cavalry 2023

    I understand the essence of what the OP wants to do, but can't get close enough to the detail to offer a solution. Can anyone get any closer to an understanding of their data and what the workbook totals are that they refer to?

    https://www.excelforum.com/excel-pro...arts-list.html

  56. #56
    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
    79,400

    Re: Call in the Cavalry 2023

    Glenn and I have tried and failed to reach an understanding in the thread linked to in post #55 - does anyone else feel like having a go?

  57. #57
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    365 32bit Win
    Posts
    1,811

    Re: Call in the Cavalry 2023

    https://www.excelforum.com/excel-pro...nts-names.html

    Anyone have experience of sensitivity labels? The button is disabled for me, but it seems like it should be a property which you could set.
    Last edited by ByteMarks; 09-19-2023 at 06:50 AM.

  58. #58
    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,093

    Re: Call in the Cavalry 2023

    @ByteMarks: have you posted the correct link? That's one I have answered and it doesn’t appear to have anything to do with "sensitivity labels".

  59. #59
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    365 32bit Win
    Posts
    1,811

    Re: Call in the Cavalry 2023

    No, sorry. I've corrected the link.

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

    Re: Call in the Cavalry 2023

    Got this PM: "Hello
    I am a new user. I only had one thread posted until now, but somehow i am not allowed to post another one.
    But I have another issue to solve and I don't know how.
    Can I be allowed to ask for help?
    Thanks for your help.
    Klemzy"
    I had helped in the following thread which is why I guess I was contacted, however it seems that this is an issue an administrator/moderator would be better able to resolve: https://www.excelforum.com/excel-for...ml#post5568795

  61. #61
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Call in the Cavalry 2023

    Quote Originally Posted by JeteMc View Post
    Got this PM
    I have PM'ed the user to find out what specifically the problem is.

  62. #62
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Call in the Cavalry 2023

    Jeff.
    Great minds think alike, I did the same without having seen your post. Well, lets hope one of us gets an answer.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  63. #63
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Call in the Cavalry 2023

    Quote Originally Posted by JeteMc View Post
    Got this PM: "Hello
    I am a new user. I only had one thread posted until now, but somehow i am not allowed to post another one.
    But I have another issue to solve and I don't know how.
    Can I be allowed to ask for help?
    Thanks for your help.
    Klemzy"
    I had helped in the following thread which is why I guess I was contacted, however it seems that this is an issue an administrator/moderator would be better able to resolve: https://www.excelforum.com/excel-for...ml#post5568795
    Quote Originally Posted by alansidman View Post
    Jeff.
    Great minds think alike, I did the same without having seen your post. Well, lets hope one of us gets an answer.
    There are two issues:

    1) He was trying to post a live link but his account is too new to do so.

    2) At the bottom of his page is a list of permissions and he doesn't have permission to do anything. Except I have the same list, and obviously I can do all these things. I have reported this bug to the tech team. Scroll to the bottom of this page and I'll bet you will see it too.

    Meantime Klemzy has successfully started a new thread, without links.

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

    Re: Call in the Cavalry 2023

    Thanks to Jeff and Alan for getting this straightened out. Hoping that the more helpful folks at Excel Forum can be, the more the word will get around and the traffic will pick back up.

  65. #65
    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
    79,400

    Re: Call in the Cavalry 2023

    I am not sure how much further I shall get with this on my own (and I'm sure there's a better way to achieve what I've already done): https://www.excelforum.com/excel-gen...ictograms.html

    Any assistance welcome.

    It's an interesting challenge academically (notwithstanding the poor data layout that could be reconfigured to make it easier).
    Last edited by AliGW; 10-05-2023 at 10:51 AM.

  66. #66
    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

    This is way out of my league! Anybody interested in helping? Thanks

    https://www.excelforum.com/excel-pro...urce-data.html

  67. #67
    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

    Inevitably it happens, a curveball. Not sure how to tackle this next question. Two matches together.

    https://www.excelforum.com/excel-gen...er-column.html

  68. #68
    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 have a suggestion for this formula?

    https://www.excelforum.com/excel-gen...utput-yes.html

  69. #69
    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
    79,400

    Re: Call in the Cavalry 2023

    The OP here is still requiring the refinement of a dynamic array solution (provided by Hans). He's feeling a bit 'forgotten' - can anyone assist?

    https://www.excelforum.com/excel-gen...tograms-2.html

    It's gone above my pay grade.

  70. #70
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Call in the Cavalry 2023

    Here is someone who just upgraded to Excel 2021 on a Mac, and when they try to select an entire row or entire column, there is nothing on the screen to indicate the selection. This may be specific to Excel 2021 for Mac, it may even be a corruption on the machine. I dunno, but I don't have a Mac.

    Any takers?

    https://www.excelforum.com/excel-gen...1-for-mac.html

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

    Re: Call in the Cavalry 2023

    Solver in my older version doesn't support all of the options in the newer versions, so I may be losing something when I open the OP's file with my version of Excel. Can some of you with a newer version open and check the Solver model and see if there is something I am missing in my older version of Excel?

    https://www.excelforum.com/excel-for...-an-error.html

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

    Re: Call in the Cavalry 2023

    The OP would like to be able to add new items to a table that is produced by Power Query. Issue is that after the original table was produced, additional columns are added. When the new items are added then the data in the additional columns is orphaned. The before is the green/white table on the Labelling data sheet in the file attached to post #7 and the after is the same table in the file attached to post #9.
    https://www.excelforum.com/excel-for...ml#post5891481

  73. #73
    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
    79,400

    Re: Call in the Cavalry 2023

    This is a maths question about geometric progression. Any takers? I have no clue!

    https://www.excelforum.com/excel-gen...ery-draws.html

  74. #74
    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
    79,400

    Re: Call in the Cavalry 2023

    Any help with creating a dynamic table that will work nicely with a chart (or vice-versa!): https://www.excelforum.com/excel-cha...e-stumped.html

  75. #75
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Call in the Cavalry 2023

    This is a pretty basic multiple lookup setup but it fails to include new data from the Table as it expands.
    Poster is on 2016 and I'm on 365, I figure someone with a pre-dynamic array version could figure this out easily.
    Darn, it was easy getting used to those dynamic arrays...

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

  76. #76
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Call in the Cavalry 2023

    OP is looking for a VBA solution to his issue. He was not fond of my Power Query Solution for multiple reasons.

    https://www.excelforum.com/excel-pro...d-quarter.html

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

    Re: Call in the Cavalry 2023

    This post (https://www.excelforum.com/excel-pro...ml#post5899205 ) started out somewhere in general excel, ended up in VBA, and I'm now asking if anyone who knows Power Query might want to comment. In short, the OP wants to extract information from a closed Excel file without opening the file in the process. It's always the same information from the same location in the spreadsheet, but a different file each day. Can anyone with experience accessing closed files in Power Query (or any other Excel tool) comment?

    I made a comment about database design. I think there might be room for someone experienced in database design to comment about the value in building good databases, too (though I'm not sure the OP is ready to accept a tutorial on better database design).

  78. #78
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry 2023

    I've taken this one as far as I can. Perhaps I simply lack understanding of golf tournaments or old age is catching up with me. Either way I do not understand.
    Last edited by FlameRetired; 12-29-2023 at 02:51 PM.

  79. #79
    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


  80. #80
    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
    79,400

    Re: Call in the Cavalry 2023

    This thread is closed. Please use the 2024 version.

    https://www.excelforum.com/the-water...ry-2024-a.html

    I've copied your post to it.
    Last edited by AliGW; 01-12-2024 at 05:29 PM.

  81. #81
    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

    Thanks Ali

  82. #82
    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,917

    Re: Call in the Cavalry 2023

    Thanks (again) Ali

Closed 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 - 2022
    By AliGW in forum The Water Cooler
    Replies: 52
    Last Post: 01-18-2023, 09:35 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