Recent Discussions
Excel Formula Help
Hi everyone, i am needing help pulling data from one sheet to another. The "DATA" tab is a bunch of data that is pulled from a Microsoft forms survey and i copy and paste it in the sheet. Once i copy and past the data i want all the other sheets to pull this data into its perspective tab. On the "DATA" tab in coloumn G is the district and each district has a different column for the module. So MRD districts module is column I, SLRD districts module is Column J, SBRD districts module is column K and so on. What i would is when data is pasted i want MRD ABC123 to pull the data from the "DATA" sheet onto this tab but it has to meet the 2 criterias. 1st criteria for the "MRD ABC123" tab is the Job Code in Column F on the "DATA" tab has to match ABC123 and the District column G in the "DATA" tab has to match MRD and then pull that data from the row on the "DATA" tab into the perspective columns on the "MRD ABC123" tab. Im just looking for a formula that will work for each column on the "MRD ABC123" tab to pull the data from the "DATA" tab. i have tried Index Match, Xlookup, and Filter functions but i know im doing something wrong. Any help would be amazing. thank you.Resizing an Excel Window
I cannot resize an excel window. It is either full screen or a small rectangle with 3 symbols on it. How does one achieve a size in between these extremes? This question has been posed before but the replies make no sense. One prior answer (2023) suggests dragging the maximized window to the edge of the screen. But it's already at the edge of the screen in full screen! What am I missing? Thanks very much. KerryUtilizing 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 ) ) )
Which formula to use to compare 2 spreadsheets that have 6 columns?
Hi, I have 2 spreadsheet, A and B, and both have 6 columns, like the table below, and more than 7k rows (6 x 7k) A B C D E F Bank Bank Code Country Bank Branch Bank Code SWIFT Code Value 1 Value 2 Value 3 Value 4 Value 5 Value 6 I would like to compare spreadsheet A and B to find which values is missing into B. And, I assume that SheetA!Value1=SheetB!Value1, SheetA!Value2=SheetB!Value2,..,SheetA!Value6=SheetB!Value6 I tried this formula IFERROR(IF(MATCH(1,(A:A=SheetB!A:A)*(B:B=SheetB!B:B)*(C:C=SheetB!C:C)*(D:D=SheetB!C:C)*(E:E=SheetB!E:E)*(F:F=SheetB!F:F),0),"Added"),"Missing"). The problem with this formula it's take a lot time to give a result. My spreadsheets have Excel is very slow and my PC is freezing. So, I don't know if this formula is good nor if there is another one that won't slow down my PC. Best regards
Access Still Struggles on Data Import
More of a comment than anything else I have been a frequent flyer of Access since version 2.0. We used it almost daily for several years. I have since retired, and was away from it for a couple years now. However, due to a recent Office 365 account I started using again. One of the problems we had over the years with Access was on large data imports. This appears to be the same problem today as it was 30 years ago. Excel does not have this problem. Some of the same issues with Access "Does not recognize header name" Checking to insure header name was not a keyword and all rules were enforced, still did not allow the data to be imported. Since I needed to quickly turn around the information I had to link to an Excel file and run the queries. Pondering if MS has really done any improvments or serious upgrades with Access. I know programs cost resources to update. The other 3 Office apps have far more users than Access. I think Access is going to wither away within the next couple years. Was a great run when everything worked right. I have used a lot of different databases over the years. However, Access was the runt who was very user friendly and an awesome reports generator.Index tab leaders don't reflect tab leaders in the Index Style
Contex: 700 page word document with multiple indexes - about 1500 index items in each of three indexes Issue: Indexes appear with dotted tab leaders in front of page number. Index 1 style (and the other levels as well) have a tabs without dotted leaders. Question: How to get rid of the dotted tab leaders if they don't follow the relevant index style when the index is updated. Note that I have tried clearing the index style changing the index style creating a clean document with good styles and copying the index definition from that document creating a clean document template with good styles and adding that (and activating it) to the document And numerous other methods that I have not documented. Any thoughts on how to address this (other than applying the style every time I update)?
Excel help requested
Hi folks I am new to the forum but have been an Excel user for a good few years. I would appreciate some advice from experts. I have a spreadsheet with several worksheets on it. The first being the entries from bank statements. I would like to have the entries on this sheet automatically added to the respective worksheet as each company my Masonic lodge uses has a separate worksheet. For example gas etc. I’ve tried to attach the sheet but it doesn’t appear to be possible. Thank you in advance. steve
Excel Formula
Hi, I'm trying to figure out which formula (if any) to use in my workbook to make it more automated. I am needing to have a formula in worksheet 4, that will go to worksheet 1, locate the word "Thursday" in column B and return the corresponding date listed in column A. For more context, worksheet 1 has information for daily testing and worksheet 4 is a report that requires specific information for Thursdays only. I've been able to automate everything except for pulling the dates from worksheet 1. I've tried VLOOKUP, XLOOKUP, IF, IFS and I just can't figure it out, as well as spending many hours trying to research which formula(s) to use. Please let me know if more information is needed.Excel - Matching outgoing to incoming inventory based a specific conditions
Hello, I wonder if anyone here can help me. I have created an inventory tracking file in excel but I have encountered a difficulty that I cannot seem to find an answer for. I have sequenced each incoming shipment but I am unable to sequence or match or track outgoing shipments automatically based on specific conditions: I need to assign #1 to outgoing shipments until outgoing piece count of 25 is reached, then #2 until 20 is reached and so on When incoming and outgoing piece count net out to 0, I need the status to be "Closed", when we've started pulling from but not emptied out yet, "In progress", and when untouched "Open" I would like outgoing to be link to earliest, not closed, incoming shipment. Of concern: "Out" and "Status" columns Can anyone help with this? Thank you! Christine
page numbering a document in word
Hello I am trying to automate page numbers in my document. I have removed all section breaks— but one. I cannot figure out the sequence of commands to “link to previous”— when I do it, it does not work. I must be clicking the wrong things because it won’t paginate. It is a long document so I really need the pages numbered. Any help in solving this would be much appreciated.How to Fix Common OneNote Issues A Complete Troubleshooting Guide
Microsoft OneNote is a powerful tool for organizing notes, collaborating, and keeping track of ideas. But like any app, it isn’t without its quirks. From syncing errors to disappearing sections, many users experience issues that can disrupt productivity. The good news? Most of these problems have straightforward fixes. https://dellenny.com/how-to-fix-common-onenote-issues-a-complete-troubleshooting-guide/How to unprotect Excel sheet if forgot the password
I recently encountered a problem and hope to get your help. I set a protection password for an Excel file before. Now I want to modify some data, but I found that I forgot Excel password. I wonder if there is any way to remove the protection or unprotect Excel sheet password? If anyone knows a related solution or has had a similar experience, please share it, thank you very much! This file is very important to me, and there is a lot of work data in it. I have tried some methods found on the Internet, but none of them worked. It would be great if someone could provide some specific steps or recommend some tools.Suggestion: Add =IMAGE() function to Excel 2016 & 2019
Hi Microsoft Team, I’m an Excel 2016 user and really appreciate the product. However, I’ve noticed that the =IMAGE() function is available only in Microsoft 365 and the web version. Many of us who are using perpetual versions (Excel 2016 / 2019) would love to see this function back-ported. It’s a small but powerful feature that makes dashboards, catalogs, and reports much more useful. Not everyone can move to 365, but we still look up to Excel for improvements. Adding =IMAGE() to 2016 and 2019 via update would make these versions more practical and user-friendly. Please consider including this in a future update. Thanks for listening and for continuing to improve Excel!IMAGE function not working
I'm trying to use the new IMAGE function on desktop Excel (win 11). Build 15726.20202 According to the availability info on https://support.microsoft.com/en-us/office/image-function-7e112975-5e52-4f2a-b9da-1d913d51f5d5?ns=excel&version=90&ui=en-us&rs=en-us&ad=us this function should work in my build. However, it seems that EXCEL doesn't recognize it and shows #NAME error.
Excel 365 Closing Every Time It Saves
I have been using the same computer without this issue for a year. Today, every time any Excel workbook attempts to save, Excel shuts down. I have tried all of the possible solutions I can find online - disabling graphics accelerator, running in safe mode - still shuts down, checking Task Manager, repairing, uninstalling and reinstalling, disabling all add-ins, etc. Nothing has worked. I do not receive an error message. Excel just saves the file and shuts down. I do not understand why this would start happening all of a sudden this morning.OneDrive not syncing
Hi, I have added a folder to my OneDrive using a browser, waited for over an hour but it still doesn't show on my PC. OneDrive on my pc says "your files are synced" which is not true. Due to the general lack of verbosity in OneDrive, there is no way to tell when it will check again or when it hat checked last. Due to the lack of ease of use in OneDrive, there is no "sync now" button I would like to stop wasting money and continue my working day, what should I do? Regards, Robert.Word: table splitting across pages
I have a table in word, I want all the rows of the table to remain in the same page when new lines are added above it. i.e. if of four rows, the last table won't fit in the page, the whole table should move to the next page. I have followed the following steps: Table properties>row> uncheck 'Allow rows to break across pages' Select all rows of table and then Paragraph>line and Page breaks> check 'Keep with next' For some reason the table still splits across pages Note: The rows on the table have different heights
Recent Blogs
- SharePoint agents are useful for tasks like answering sales questions or onboarding new hires.Sep 18, 2025
- We’re making changes to the Microsoft 365 Copilot app for iOS that put key AI-driven capabilities and experiences front and center.Sep 17, 2025
