Recent Discussions
Advanced Formula Environment module function description
In the advanced formulas it allows for modifying the description that is used in Name Manager for everything but the modules. For functions in modules the only way to access the description is by opening the Name Manager after the module is saved. But the description is overwritten with empty string when the module is changed and saved again. Is there a way to add Descriptions to the formulas with comments or some similar? Ex: //Description: Reverses Characters of a String REVERSE_STRING = LAMBDA( ... If there's not a way to do it yet, could it be added in a future update? --BLWSolved18Views0likes2CommentsAccess changing lettercase - redux
This has probably been beaten to death, but I'm fuming, so here goes. I want Microsoft to DO SOMETHING to help. Access has the highly annoying habit of changing lettercase on identifiers, seemingly at random. This is a real pain when using add-ins like MSAccessVCS, which makes it possible to use git for source code control. Here' what I've deduced is happening: There exists a dictionary/symbol-table containing every identifier used in a project. The symbol table contains ALL identifiers, including those defined by MSAccess, referenced libraries, and your code. Searching that table is case-insensitive, but it stores the canonical version of the identifier with case preserved. Normally, when you type an identifier that already exists in the table, the VBA editor "corrects" the lettercase of your entry to match the table's entry. The extremely annoying part is that sometimes that last step works in reverse. You type an existing identifier, but with a different lettercase. Instead of correcting what you typed to match the table, it instead updates the table with the version you typed, and decides that's the way future and existing identifiers should be spelled. Here's a recent example. I tried to create a class module constructor (Class_Initialize) but typed it "class_initialize" implicitly expecting that the VBA editor would "fix" it. Instead, it updated the symbol table and set the canonical lettercase to the all-lowercase version... and then proceeded to change the lettercase on the Class_Initialize() method in all my class modules. It has now decided the canonical lettercase is "class_initialize" and that's what it "corrects" to from now on. Of course, when I did the next MSAccessVCS export, git showed a bunch of unwanted (but cosmetic) changes. This pollutes the changeset and makes source control more difficult. THIS. IS. A. BUG. My workaround is, when starting a checkin, I go through the list of changes and group all such changes into one commit called "VBA Artifacts". But come on, this shouldn't be necessary. At least let us know WHY this happens, and give us some control of the process. A way to specify/correct the canonical casing would help.42Views0likes1CommentPower Automate Flow moving Attachments in Email to MS List - can it get a Email as an attachment?
Created a Flow to get Emails from Outlook using Graph API to extract all metadata into columns in a MS List including attachments of the Email into a column in the MS List with the name as a hyperlink in the same site as the list; but when there is another Email as an attachment it does not come into the MS List. Is there such a limitation in MS Flow where it cannot get the Email attached in an Email as an Attachment?11Views0likes1CommentUtilizing Excel's turing capabilities to create Conway's 'Game of Life'
The Background It's been said with Lambda (and LET and a wealth of functions in 365) Excel has become 'turing-complete'. To quote the article linked below: "You can now, in principle, write any computation in the Excel formula language." https://www.microsoft.com/en-us/research/blog/lambda-the-ultimatae-excel-worksheet-function/ The Challenge I thought it would be fun to create Conway's 'Game of Life' in Excel 365 to see how far I could push things. Conway's Game of Life - Wikipedia The rules are simple: A 'cell' has up to 8 adjacent cells (less if the cell is on the edge of the board). A 'neighbor' is a cell with a 1 while a 'dead' cell is empty. An 18x18 board Multiple iterations Bigger boards! more (it's relaxing to create new shapes and designs) The Approach My first thought was to use MAKEARRAY because I could use 'r' and 'c' coordinates and there would be no stacking. I devised a recursive function that worked for 1 iteration but failed on subsequent iterations because the use of TAKE/DROP was slowly shrinking the board! The revised approach is essentialy a recursive MAP that uses 3 arrays: the input matrix, the 'r' array (row numbers) and the 'c' array (column numbers). It's my way of using r/c without using MAKEARRAY. For Discussion I welcome any improvements to the existing function and any different approaches someone may have to creating Conway's Game of Life. Conway Lambda follows: Conway =LAMBDA(matrix, iterations, IF( iterations = 0, matrix, Conway( LET( height, ROWS(matrix), width, COLUMNS(matrix), r_arr, SEQUENCE(height) * SEQUENCE(, width, 1, 0), c_arr, SEQUENCE(height, , 1, 0) * SEQUENCE(, width), CheckNeighbors, LAMBDA(lattice, r, c, LET( RCx, LAMBDA(row, col, IFERROR(CHOOSECOLS(CHOOSEROWS(matrix, row), col), 0) ), N, RCx(r - 1, c), NE, RCx(r - 1, c + 1), E, RCx(r, c + 1), SE, RCx(r + 1, c + 1), S, RCx(r + 1, c), SW, RCx(r + 1, c - 1), W, RCx(r, c - 1), NW, RCx(r - 1, c - 1), compass, VSTACK(N, NE, E, SE, S, SW, W, NW), neighbors, SUM(compass), IF( AND(lattice = 0, neighbors = 3), 1, IF( AND(lattice = 1, OR(neighbors = 2, neighbors = 3)), 1, 0 ) ) ) ), MAP(matrix, r_arr, c_arr, CheckNeighbors) ), iterations - 1 ) ) )2KViews3likes19CommentsHow to sort multiple columns independently by date order that have text in the same row in Excel?
How to sort multiple columns by date order that have text in the same row in Excel Professional Plus 2024? I'm trying to create a spreadsheet with multiple columns that has text as well as dates & I need to be able to sort each column independent of the other columns with the oldest date first no matter what row the data was put in. date of incoming order from: date of payment from: date of outgoing order from: 4-5-25 ABC Company 4-23-25 XYZ Company 4-25-25 EFG Company 3-7-25 EFG Company 4-19-25 ABC Company 5-9-25 XYZ Company 4-11-25 XYZ Company 4-12-25 EFG Company 4-23-25 ABC Company Thanks for any help!32Views0likes1CommentHeader adjustment
I am having an excel file where I need to put the sheet numbers. Cells 1A to 6L is added in the rows to be repeated in all sheets. I have added the page number in the header and could adjust it vertically to appear where it is supposed to be however for the horizontal adjustment couldnt be done .. Appreciate any guidance for the same as per the snap I have attached.18Views0likes1Comment#unknown! displayed in excel where an inserted picture should be located
A supplier is sending me an excel template which contains pictures in a cell The picture can be viewed in web based outlook and web based excel but when I download the file the cell states #unknown! I believe the supplier is using a personal 365 account and I am using 365 Apps for enterprise I think they are adding the picture by completing the below (taken from MS site) this is what I see when I open it up on web based outlook But this is what I see when I download an open in excel desktop Any help is greatly appreciated49KViews1like16CommentsHow to highlight the 5 lowest values in a column that exceed 1000
I am wanting to apply conditional formatting to a column of data to highlight the 5 lowest values that exceed 1000. I have not been able to find anything that works with over 2 hours of Google searches and trial and error. My data is in cells B18 through B67. Thanks in advance to anyone who can provide a solution.Solved31Views0likes2CommentsAutopopulate formula across worksheets?
I am trying to create a lunch schedule for the year with approx 30 people. Each day a new person will be chosen (with their initials on Picture 1), and then it will automatically rotate (sheet 1). Sheet 2 will have their name, the date of their scheduled lunch, and what they are bringing. How do I autopopulate the date from sheet 1 to sheet 2? Also it's not exactly perfect, because people get sick or are away, and then I have to substitute someone else who is coming that day to do lunch, and I want the date to autopopulate as well on Sheet 2 when I have to make a change on Sheet 1. Hope what I'm asking for makes sense. How do I do this?80Views1like3CommentsVBA Code for List Box Change
Hello, I'm having issue trying to setup an Excel worksheet, used as a form. Line 8 (J8, which I named the cell Question1) has a list box that is either "Please Select", "Yes", or "No". When there is a change I would like VBA code ran that deals with the selection made. If "Yes" then hide the next question, which is line 10. If the selection is "No" then just go to the next question. In the VBA editor I have top part of the below screenshot. It calls a macro, which is the second part of the below screenshot. When I choose Yes or No from the first question nothing happens besides the cell changing from Please Select to Yes or No (depending on what I change it to). What am I doing incorrectly? Thanks.43Views0likes3CommentsDo not paste into cells that already contain data
I want to copy a range of data somewhere else in my sheet, but I do not want the values to overwrite any data that may be in any of the target cells. This is effectively treating what I have copied to the clipboard as default values, which will almost certainly be different next time I copy data.6.6KViews0likes5CommentsNew Landing Pages for Word, Excel and PowerPoint (rant)
So I found out this week that MS is piloting new landing pages for the core Office apps (again). Instead of loading in the M365 Home page, they now load in an entirely new page. Why was this necessary? We've already been here before and MS spent years moving everything to the Home app. The dust has finally settled and things are working great. Why move things out again?7Views0likes0CommentsOffice 365 Excel stopped auto-expanding a table
I've done some searching, but traditional fixes like checking the options (O365 doesn't have those), clearing data under the table, and creating a macro (I shouldn't need to do this to fix what I did not break) are a no-go. My shared workbook has a table that has suddenly stopped auto-expanding when adding another row. I'm up to 669 rows. It stopped working at 666, so that's not suspicious at all... Columns A-AZ are populated with extensive formulas on about half of them. Any ideas? I've dumped like 80 hours into this workbook and really don't want to re-make it.14KViews1like12CommentsCalculating percentage of column in date range
I am trying to work out a way of calculating the percentage of staff who have completed training within the last year within a column to flag up our overall training compliance. I have already used conditional formatting stay green if in date, yellow when 90 days off date for training due and red if the date has past. I use the expiry date in the future as the entered number so if they complete today (24/4/25) I would enter 25/4/26. I am only using one column for dates so would want values from B2 to B86 to be counted and the percentage of dates that have not gone past today to be worked out as a percentage and put at the bottom of the column in B88. I also want to have a system that can have staff added and deleted as they join/leave without messing up the formula calculation if that is in any way possible. Many thanks22Views0likes1CommentCharts- doubt_1
Dear Experts, I have a Data as below , in worksheet named "Data" and need to create charts as in Worksheets "Chart-1" and "Chart-2", Could you please help share on how to do that, I tried Pivot, then Scatter-plot can't be used, is there some limitation? Br, AnupamSolved72Views0likes9Commentspre-1900 dates
I can find no help on how to tell Excel to properly format and calculate dates before 1900. I want to calculate age at death and have birth and death dates in columns. But Excel does not recognize March 30, 1894. It calls is YYYY = 3794. And subtracting death date from birth date returns "#VALUE!" How do I use the DATE(YYYY,MM,DD) function or format March 30, 1894 so Excel will understand and I can have it calculate the age at death correctly? TIA. Also I've seen #1 shown in Excel Help in different posts as BOTH Dec 31, 1899 AND as Jan 1, 1900. Which is it?63KViews0likes22CommentsPivot Table with some data
Hey All, I have a data source attached that outlines crime, I want my pivot table on the 'Type AD' tab to show the crime that occurs on private property. I created a column in my original data 'Comparative 2020' to outline private or public property next to the data that happens in the Arts District. I only want what is public/private for that specific district, can that be added to my graph on the 'Type AD' tab? I also want it to reflect in a different color and the total. I'm not sure that because I don't have data for January that it will work...help! Thank you!Solved1.3KViews0likes7Comments
Events
Recent Blogs
- 4 MIN READAt Microsoft, building community and diversity and inclusion is at the heart of our mission to empower every person and organization on the planet to achieve more. The Microsoft 365 Community Confere...Apr 22, 2025107Views0likes0Comments
- Ready to level up your Microsoft 365 and AI skills? Join us at M365Con 2025 in Vegas!Apr 21, 202589Views1like0Comments