Forum Widgets
Latest 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? --BLWSolvedNoeotbsApr 25, 2025Copper Contributor35Views0likes2CommentsUtilizing 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 ) ) )Patrick2788Apr 24, 2025Silver Contributor2.1KViews3likes19Commentsgraph
I need help creating the last graph. My computer will not format the x and y axis the way I need them to.Jess9790Apr 24, 2025Copper Contributor1.5KViews0likes3CommentsAdding up column totals.
Hi, Trying to add up values in Column G2, G2772. Can't get autosum to work right. In cell 2773 I click "Autosum" and enter cell G2, G2772 and the value in G2773 comes up 0.00. I don't know what I am doing wrong. Someone please help. ThanksSolvedcardsfaninmoApr 24, 2025Copper Contributor57Views0likes2CommentsHow 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!torisfallApr 24, 2025Occasional Reader35Views1like1CommentHeader 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.SreekanthGApr 24, 2025Copper Contributor24Views0likes1Comment#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 appreciatedAButler1910Apr 24, 2025Copper Contributor49KViews2likes16CommentsHow 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.SolvedsheldonmartinApr 24, 2025Occasional Reader41Views0likes2CommentsAutopopulate 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?riciarishApr 24, 2025Copper Contributor87Views1like3CommentsVBA 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.mzeller1776Apr 24, 2025Copper Contributor47Views0likes3Comments
Resources
Tags
- excel42,599 Topics
- Formulas and Functions24,714 Topics
- Macros and VBA6,408 Topics
- office 3656,025 Topics
- Excel on Mac2,653 Topics
- BI & Data Analysis2,373 Topics
- Excel for web1,917 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,635 Topics