Recent Discussions
Double Thunking Works Wonders!
Given that most Excel users would not dream of employing one thunk, you might well ask why even consider nested thunks! The use case explored here is to return all the combinations by which one might choose m objects from n (not just a count of options =COMBIN(n, m), but the actual combinations) Knowing that sometimes allows one to deploy an exhaustive search of options to determine the best strategy for a task. Before considering the task further, one might ask 'what is a thunk; isn't it far too complicated to be useful?' All it is, is a LAMBDA function that evaluates a formula when used, the same as any other function. The formula could be an expensive calculation or, rather better, no more than a simple lookup of a term from a previously calculated array. The point is, that whilst 'arrays of arrays' are not currently supported in Excel, an array of functions is fine, after all, an unrun function is little more than a text string. Only when evaluated, does one recover an array. In the example challenge, each cell contains an list/array of binary numbers, which might itself run into the hundreds of terms. A '1' represents a selected object whilst a '0' is an omitted object. Rather like the counts of combinations obtained from Pascal's triangle, each cell is derived from the contents of the cell to the left and the cell above. This is SCAN on steroids, accumulating array results in two directions. Running down the sheet, the new combination contains those of the above cell, but all the objects are shifted left and an empty slot appears to the right. These values are appended to those from the left, in which the member objects are shifted left but the new object is added to the right. So the challenge is to build a 2D array, each member of which is itself an array. The contents of each cell is represented by a thunk; each row is therefore an array of thunks which, for REDUCE to treat it as a single entity, requires it to be securely tucked inside its own LAMBDA, to become a thunk containing thunks. Each pair of rows defined by REDUCE is itself SCANned left to right to evaluate the new row. By comparison the 2D SCAN required for the Levenshtein distance which measure the similarity of text strings was a pushover. I am not expecting a great amount of discussion to stem from this post but, if it encourages just a few to be a little more adventurous in the way they exploit Excel, its job will be done! p.s. The title of this discussion borrows from the Double Diamond advert for beer in the 1960s2KViews2likes28CommentsHow to summarize by date range and grouping customer items
We have a table to summarize such that data is arranged by customer within specific dates. For example, 26 th to end of month plus the next 25 days as shown in this figure. How can this be done with dynamic array functions with possibility to change date range? E.g 16 th to 15 th, or 21 st to 20 th .21Views0likes1CommentWord on iPhone
In the past, I’ve managed to edit some documents on my iPhone in Microsoft Word. But now Microsoft is slapping me in the face with grammatical suggestions that obscure my document. I don’t want any grammatical suggestions, but I can’t figure out how to make them stop. Can anybody suggest how I can do that? Am I in the right place to ask this question? Is there another place for the iPhone app?38Views0likes2CommentsWord mac issue
Hello, I want some help. I have a user who has a Mac Word file she needs to recover. She is stating that the file is hidden; she worked on the file, and then her computer restarted and lost the document. I told her to check the recycle bin to see if its in there. She said she created the file, modifying it from a previous file, and now it won't let her open the file. She then said this I found the missing text. The hidden document is visible in a shadow-like form. When she went to rename the document, there was no dot at the beginning of the file name. The renaming process did not result in the document being made visible? Can I get some help please?28Views0likes2CommentsGroup Timeline chart by unique values
I have a table in an excel spreadsheet in which we plan the team's vacation days (fig.1) Note: in Brazil we can take up to 3 periods in a year - totalling 30 days - and 10 of those can be sold: you receive extra money and only take 20 days off on column B the worker puts his name, column C-D the worker inputs start and end day of each vacation period the other columns serve no purpose for the graph my question is about Then, I select A2:J13 range and create a pivot table/chart with the following fields (fig.2) My question is if there's a way to overlap the periods for a same worker (Samwise for example) Each worker should have only one line and all vacation periods be on it (because 3 years from now there would be so many lines that the graph wouldn't be nice to see the time periods each one is on vacation)12Views0likes0CommentsFinding a "2 cell" name in anther sheet and copying data
Hello- I'm looking for a formula to enter in column D of the Main Sheet. I would like to find the "Total" in sheet: 2023 for the name in cells A&B, and copy them into the Main Sheet. The names are in a different order in each sheet. I've tried XLOOKUP, but couldn't make it work. Any ideas?28Views0likes1CommentUnlocking the Power of SharePoint Embedded A Modern Approach to Content Management
n today’s digital workplace, organizations rely on collaboration and content management tools to keep teams connected and productive. While SharePoint Online has long been a go-to platform for document management and intranet experiences, Microsoft has introduced a new game-changer: SharePoint Embedded. So, what exactly is SharePoint Embedded, and why should businesses care? Let’s dive in. https://dellenny.com/unlocking-the-power-of-sharepoint-embedded-a-modern-approach-to-content-management/9Views0likes0CommentsNo puedo abrir mi Excel, ningún archivo.
No puedo abrir ningún archivo de excel, se queda cargando pero no abre. Solo puedo abrirlo en modo seguro. He quitado los complementos y aún sigue sin abrir. He desinstalado e instaldo Office 365 y aún sigue sin abrir, se queda cargando. Espero que alguien pueda tener la solución a este incoveniente. Los demas programas me abren (Word, PPT...)5Views0likes0CommentsTable Properties for table inserted into Word document
Where can I find the default settings for Table in Word? Currently when I insert a table, I might find the row not wide enough. And often, it was because of the row height being set as "exactly" and I have to set it as "at least". Where can I set the default as "at least" so that it does not always use "exactly"?3Views0likes0CommentsConditional formatting across sheets
I have a sheet which manages the works of multiple budgets. One sheet provides an overview of the budget and the next show the various schemes attributed to the numerous budget codes. Currently I have to flip back and forth to see whether the budgets have available monies before progressing a scheme but with a high number of jobs each day this can be quite time consuming. I would like a formula to format the budget name cell in the second sheet (B:B) when the value in the available budget column (J:J) relative to the specific budget name (B:B) both in the first sheet, is showing as a negative figure.Solved41Views1like2CommentsMicrosoft Introduces Restore Capability for Conditional Access Policies
New Graph APIs allow Entra administrators to restore a conditional access policy with a Graph request. This article explains how to list, restore, and permanently remove soft-deleted conditional access policies using Graph API requests run in PowerShell. Being able to restore conditional access policies removed in error closes a big gap, especially if agents might begin working on policies. Who knows what errors might happen in future. https://office365itpros.com/2025/10/03/restore-a-conditional-access-policy/16Views0likes0CommentsCountif/Countifs
I'm trying to do a standard countifs formula for several columns of information. Each column is using the same criteria but has different ranges. I'm trying to make an equation that will be easy to drag so I do not have to rewrite the range each time. Does anyone know how to do this? I have cells with the prewritten ranges I'll want to use. I can give more information if that helps people understand.59Views0likes4CommentsMacro to copy
Hello all you "Brilliant Minds" here is a chance to prove your "Excel-ence. I want to copy a value to one cell from the source which is random and as I haven't a clue about this stuff I asked Microsoft CoPilot. Being on the 4th version Where Microsoft excel still will not accept Microsoft CoPilot's creation, I am appealing to the Community. So here is your chance to prove that you are smarter than CoPilot. Here we go, everything but attach a file. If anyone is interested send me an email so I can send a couple of small files. Donald142Views0likes13Commentsremoving unwanted data from a cell
I have a column with codes, the codes I need are FT and FC, but there are cells with extra codes which I want to remove and only have FT or FC appear in the cell. how do I do this without having to click on each cell and remove the unwanted data? example attachedSolved730Views0likes9CommentsWhat is the formula for counting each number from 1to25 that hits from each drawing?
I want to calculate the daily numbers for cash25 lotto. The numbers are drawn on Monday, Tuesday, Thursday, and Friday of each week. Six number from 1 to 25 are drawn each time. I have 157 rows and 7 columns (A-G). The first column is the date and Columns B-G are each number that was drawn. I know I need to do a count in each column of the total times each number is drawn. What is the formula I should enter? Help, please!8Views0likes0CommentsCustom Sparkline Formula
I am in the process of moving to Excel from Google sheets. I am trying to build a project sheet and add a formula that will provide a "sparkline" for quick reference of the projected start and end dates, and then based on the status of the task (not started, in progress or complete) and today's date in relation to the start and end dates of the task, change color (Green, yellow, red, etc). Here is the formula I use in Google Sheets, but I cannot get it to work in Excel. =SPARKLINE(if(OR(today()<D5,today()>E5),{int(D5)-int($D$2),if(D5=E5,1,int(E5)-int(D5))},{int(D5)-int($D$2),today()-int(D5),1,int(E5)-today()}),{"charttype","bar";"color1","white";"color2",if(G5="Complete","grey",if(today()>E5,"red",if(AND(today()>D5,today()<E5,G5="Not Started Yet"),"darkred",if(AND(today()>D5,today()<E5),"orange",if(G5="In Progress","orange",)))));"max",int($E$2)-int($D$2)}) In this formula, Column D represents the start date and Column E represents the specific task end date. D2 and E2 represent the Project start and end date. Any Advice?Solved28Views0likes2Comments
Events
Recent Blogs
- Copilot Memory remembers key facts you choose to share, so Copilot can tailor its responses and recommendations to fit your needs.Oct 03, 2025272Views0likes0Comments
- This feature gives you control over how Python initializes in your workbook, allowing you to tailor imports, defaults, and configurations to suit your needs.Oct 02, 2025357Views0likes0Comments