Forum Widgets
Latest Discussions
Filtering an Array based on a list of Criteria
I have an array that tracks every project that every project manager, project engineer, and superintendent is on and I am trying to set up a function to search through a single list of names and return just their projects. The PM, PE, and SUP on the array all have their own columns since there can be 1 of each on a single project. and the list im pulling from is within a single separate column pulling on the names I select. I have had success pulling from one column at a time using a FILTER(ISNUMBER(MATCH)) function but I cant get it to search and return all values from all three columns. Any thought on how to expand the search? Thank you!
How XLOOKUP arguments apply in this case
I'm not an Excel newbie, but I have never had cause to use XLOOKUP, INDEX, or MATCH before. I'm not understanding how the xlookup arguments would apply in my case or if index/match would be better. I have an array with months as my row headings and dates as my column headings. The array itself is filled with number of pages read each day. I'm trying to have a cell indicating on which date I did the maximum amount of reading. So I want to start with the max value of my array and return the month (row) and date (column) heading using xlookup. Whether those are in one cell or two, doesn't so much matter - it's a hobby tracker, but no matter how I try and call this, I end up with a value error So for example, I would want this to return January 3rd. Every example I'm finding seems to show how to input Jan 3rd and return the value 758. What am I missing to look this up the other way around? Should I be using index or match instead?
Text to Column
Hello Everyone. I'm trying to split data into 2 columns. The original data is made up of cities and states: Notice that some items have a comma and others don't. Also, the cities states are different lengths. So, I cannot use a space or a comma as a delimiter. I'm trying to figure out how to separate them. I came up with this formula to add a colon so I can use the delimiter to separate them. The problem then becomes the fact that I have to count the number of spaces in each city to add the colon. Then, I have to copy and paste special as values. Also, notice that in New Orleans (for example), it keeps the comma: One more issue, if I get a new report with added cities and states, then I have to re-do the calculations. HELP!!!! Balta
Using calculated columns in pivot table
I already used calculated fields to get some datas in my pivot table. They're displayed as count or sum. I want to make a new calculated fields using a Sum of working time, divide it with the number of operations. How can I use the count and the sum ? Right now, it doesn't seem to use the sum nor the count : Here I want Sum of MBTF to be : Sum of working time/ Count of Stop but the values in Sum of MTBF seems to use the values in Stops (they are dispalyed in my original table as 6/7 numbers, but I used the function count to only get the number of occurences). I believe that's the thing causing my Sum of MTBF to show 1.68E-07 numbers ( for the first line it should be 52.001) : How can I get to have a column displaying the right values (52.001, and others for each line) ? Thank you in advance for your help !
File always corrupt
Anyone have the same problem with me? I use microsoft excel 365 on my mac. At the beginning everything alright, until i use formula and then save the file. When i want to re-open the file, the messagebox showed up "we found something wrong in your content...". It gives 2 option, yes and no. If i click no, the file wont open. If i click yes, the file open, the excel do the recovery, the file open but end up with all the formulas is gone, deleted by excel and just left the value. What should i do? Do the file can still be fixed?Excel repair strips all formulas from large .xlsm after March 2026 security update (KB5002849)
Hi everyone, I'm a master's student at Karolinska Institutet in Stockholm. My thesis is a health economic cost-effectiveness model built entirely in Excel — a gender-neutral static Markov cohort model with 34 worksheets. The file has become completely unusable after what I believe is the March 2026 security update, and I'm running out of options. The file: - .xlsm, ~46.5 MB compressed, ~370 MB uncompressed XML - 34 worksheets, four of which are 73–92 MB each (Markov trace sheets) - ~65,000 formulas, ~33,500 shared formulas - Heavy use of LET, LAMBDA, XLOOKUP, XMATCH, CHOOSECOLS, TAKE, MAP, SWITCH - 771 defined names including ~147 hidden _xlpm.* LET/LAMBDA variable placeholders - Stored on OneDrive via KI SharePoint, 34,000+ AutoSave revisions - Contains VBA (vbaProject.bin) The problem: Every time I open the file — on Excel for Mac or Excel Online — the repair engine triggers and strips ALL formulas from every sheet, replacing them with cached values. The file shrinks from ~46.5 MB to ~26 MB. Clicking "No" on the repair dialog just closes the file. There is no way to bypass the repair. What I've verified: - Extracted the .xlsm as a ZIP and confirmed all formulas (<f> tags) are fully intact in the raw XML - Libr€Office Calc can read the formulas but cannot execute them (Err:508 — no LET/LAMBDA support) - Removed 158 broken named ranges (#REF! and #NAME? entries) from workbook.xml and rebuilt the archive — repair engine still strips all formulas - The issue reproduces on every OneDrive version history copy (up until I largely used LET formulas in my sheets - but there is still 1,5months of changes lost) - The issue reproduces on both Excel for Mac and Excel Online Suspected cause: The March 10, 2026 security update (KB5002849) patched CVE-2026-26108, a heap overflow in Excel's file parsing during loading. The same patch was applied to Office Online Server (KB5002846). I believe the tightened parsing now rejects or flags my file's large XML structures as potentially malicious, triggering the repair engine to strip all formulas. This is consistent with: - The known _xlfn. namespace bug on Excel for Mac (reported by multiple users on Microsoft Q&A since late 2024) - The timing - the file was working before this update flawlessly up until March 16th - The fact that Excel Online is also affected (same server-side patch) My questions to the community: 1. Has anyone else experienced formula stripping on large workbooks after the March 2026 update? 2. Is there a way to bypass the repair engine on Mac, or roll back the specific security patch without downgrading all of Office? 3. Would opening this file on Windows Excel (pre-patch or current) preserve the formulas? If anyone with a Windows PC would be willing to try opening and re-saving this file, I would be incredibly grateful. 4. Is there now effectively a size/complexity ceiling for Excel workbooks that makes models like this unviable? If so - should I be migrating this to another environment (R, Python, etc.) going forward? This file represents six months of thesis work. The formulas are all there in the XML. I just need Excel to stop destroying them on open. Any help, pointers, or similar experiences would be hugely appreciated. Thank you, Florian Boschek
