Does a LET variable get computed even if it's only referenced inside IFNA's fallback argument?
In the formula below, expensiveMatch is defined in LET but only referenced as IFNA's fallback argument: =LET( matchRow, XMATCH(1, (A1=Sheet2!$A$1:$A$1000)*(B1=Sheet2!$B$1:$B$1000)), x, INDEX(Sheet2!$C$1:$C$1000, matchRow), expensiveMatch, INDEX(Sheet3!$C$1:$C$500, XMATCH(A1&B1, Sheet3!$A$1:$A$500&Sheet3!$B$1:$B$500)), IFNA(x, expensiveMatch) ) Question: When x resolves successfully (no #N/A), does expensiveMatch still get computed because it's a top-level LET variable - or does Excel skip it since IFNA's fallback argument is never reached? I know IFNA short-circuits its fallback argument, and LET avoids recomputing a variable if referenced multiple times - but I haven't found much documentation on the behavior of Let. Is the below a more efficient way to write the formula? =LET( matchRow, XMATCH(1, (A1=Sheet2!$A$1:$A$1000)*(B1=Sheet2!$B$1:$B$1000)), x, INDEX(Sheet2!$C$1:$C$1000, matchRow), IF(ISNA(x), INDEX(Sheet3!$C$1:$C$500, XMATCH(A1&B1, Sheet3!$A$1:$A$500&Sheet3!$B$1:$B$500)), x ) ) Is this restructuring necessary, or does the first version already skip the unused computation? Basically I'm wondering if Let computes lazily/defers calculation in the way SQL's optimizer works. Input from anyone with insight or knowledge into the calc engine would be greatly appreciated. Thanks (Currently on Microsoft Excel for Microsoft 365 MSO (Version 2607 Build 16.0.20228.20190) 64-bit)
Using Data Analysis tool pak to create histograms
Hello I am trying to create a histogram for the data on acorn size in mm for two collection sites. Site 1 is titled Creek, and site 2 is titled River. RIVER Site data is: 5.8 5.2 5.7 4.2 4.1 4.7 4.1 4.4 5.1 4.8 4.8 4.7 4.2 4.3 5.5 4.1 3.8 4.1 5.3 3.9 4.2 3.9 2.9 4.1 4.7 3.1 3.1 5.0 3.6 3.2 CREEK Site data is: 3.6 3.0 2.9 3.0 2.6 3.1 3.2 3 3.2 2.9 3.1 3.1 3.2 2.9 3.1 3.1 4.9 5.1 3.2 3.1 3.3 2.8 2.9 2.8 2.9 2.4 2.9 3.7 3.3 3.2 My question is how do I use this data with the data analysis tool pak to create a histogram. What goes into the input, and what would the bin range be? Please help I'm so lost! Thank you, JamesOneDrive files opened from Finder not recognized as cloud files on Mac
Office for Mac: OneDrive files opened from Finder no longer recognized as cloud files – AutoSave disabled Hi everyone, I am experiencing a persistent issue with Microsoft 365 for Mac and OneDrive that started suddenly around August 10, 2026. The same setup and workflow had worked without problems for more than two years before that. Problem My Office files are stored in OneDrive and synchronized to my Mac via the standard macOS File Provider. When I open an Excel or Word file by double-clicking it in Finder, the Office application opens the file, but it apparently does not recognize it correctly as a OneDrive/cloud file. For example: AutoSave is disabled real-time co-authoring does not work as expected when I try to enable AutoSave manually, Office behaves as if the file were local and asks me to upload/save it to OneDrive – even though the file is already stored and synchronized in OneDrive However, if I open the exact same file from within Excel or Word via the OneDrive/Online Locations option, everything works correctly: AutoSave is enabled immediately co-authoring works changes made by another user appear in real time This behavior is reproducible with multiple files and affects both Excel and Word, so it does not appear to be an issue with one particular workbook or application. Environment MacBook Air M2 current macOS version current Microsoft 365 version current OneDrive version OneDrive Personal files synchronized through the standard macOS File Provider I have also tested opening files directly from: ~/Library/CloudStorage/OneDrive/... The result is the same: when opened from Finder, Office does not appear to recognize the file correctly as a cloud file and AutoSave remains disabled. Troubleshooting already performed I have already: completely reset and reconfigured OneDrive allowed OneDrive to fully resynchronize verified the files and folders in OneDrive on the web confirmed that OneDrive reports everything as synchronized restarted Finder and macOS removed and recreated Finder shortcuts/favorites tested without Finder favorites or aliases tested directly from ~/Library/CloudStorage/OneDrive updated macOS updated all Microsoft 365 applications updated OneDrive None of these steps changed the behavior. Key diagnostic result The following comparison is consistently reproducible: Finder → OneDrive file → double-click → Excel/Word → AutoSave OFF → file appears not to be recognized as an active OneDrive cloud document → co-authoring does not work correctly Excel/Word → Open → OneDrive/Online Locations → same file → AutoSave ON immediately → cloud functionality works → co-authoring works correctly This suggests that OneDrive synchronization itself is functioning correctly. The issue seems specifically related to the handoff between macOS Finder / Apple File Provider / OneDrive and Microsoft 365 for Mac when a OneDrive file is opened from Finder. Important detail This is not a workflow that has never worked on macOS. For more than two years, we routinely opened our synchronized OneDrive Word and Excel files directly from Finder. Office recognized them as cloud files, AutoSave was available, and collaborative editing worked normally. The behavior changed suddenly around August 10, 2026, without us intentionally changing the OneDrive folder structure or our workflow. Question Has anyone else encountered this recently? In particular: Is this a known regression in Microsoft 365 for Mac, OneDrive for Mac, or their integration with Apple's File Provider? Why would Office recognize a file as a OneDrive cloud document when opened through the application's Online Locations, but not when the exact same synchronized file is opened from Finder? Is there a way to reset or repair the Microsoft 365/OneDrive cloud-file recognition or File Provider integration without resetting the entire OneDrive again? Are there any relevant logs, caches or diagnostics that could show why Office considers a Finder-opened OneDrive file to be local? Opening every document through the Office application's Online Locations is a possible workaround, but it is not a practical long-term solution when working with a larger shared folder structure in Finder. I have already contacted both Apple Support and Microsoft Support. Apple referred me to Microsoft, and Microsoft Support subsequently recommended that I raise the issue here in the Tech Community. Any insight from Microsoft staff, MVPs or others familiar with Microsoft 365 for Mac, OneDrive and the macOS File Provider would be greatly appreciated.Sorting column groups having shared rows?
I recently organized a spreadsheet representing participants in a Ham Radio group. Though there is a base group of regular participants, we often have new folks joining us. I like to maintain a list which holds everyone's Call-Signs, first name, and state, so I can easily recognize infrequent members. I like to see the list (currently ~100, sample attached) within one screen, sorted by Call, so I arranged the data in four basic columns (Call, Name, State, Notes), then repeated the column group across the screen page. The problem is that as new members are added, their information cannot simply be added at the end of the list, then resorted. I'm trying to avoid having to move a long list up/down or typing in a Call and using the "LOOKUP" feature to get the member's info. Is there a way Excel can SORT BY "Call" only a group of columns, in this case four columns, without affecting data sharing the same row? Doing so would allow me to always have a Call sorted list, featuring four 4-column data sets, shown on one screen. I appreciate your help in advance.....I know I'll have other issues as our member list grows beyond one screen full!!!
linear interpolation of sparse data
I have several lists of data, each sampled at different varying intervals. I want to merge them into an average set of readings, but since they are each missing data and have readings at different times, I need to first fill-in all missing data using some (linear) interpolation. For example; I want to merge all three months of data into one average month summary: 1-Mar 0 3-Mar 2 10-Mar 8 14-Mar 11 17-Mar 14 21-Mar 14 24-Mar 19 28-Mar 22 31-Mar 33 1-Apr 0 1-Apr 0 7-Apr 2 11-Apr 2 18-Apr 3 21-Apr 9 25-Apr 10 28-Apr 14 30-Apr 14 1-May 0 5-May 3 9-May 4 12-May 8 16-May 9 23-May 13 26-May 16 30-May 17 31-May 18 1-Jun 0 1-Jun 0 6-Jun 3 9-Jun 7 13-Jun 9 20-Jun 15 23-Jun 19 30-Jun 22A problem: convert Arabic pdf file to Excel make strange letters
Hello, I've to convert a pdf file into Excel file for essential task in my work but unfortunately the arabic letters changed into strange letters and symbols as shown. Please help me to fix that. Alhamdulillah, the problem 's been solved. For anyone that may face such issue This is the way I used : - convert the pdf file into an Arabic word file through an online convertor that "supports Arabic Language" (not Adobe) - copy the table contents -in word file- to a new blank excel sheetAutoSave disabled when opening SharePoint-synced files from Finder after macOS Tahoe 26.6 update
Files stored in SharePoint Online and synchronized locally through OneDrive are opened as local documents when launched from Finder. Office applications display "Saved to my Mac" and AutoSave is turned off by default. However, opening the exact same files through Word/Excel > Open > Sites, or via SharePoint "Open in Desktop App", correctly identifies them as cloud documents. In that scenario, AutoSave is enabled and collaboration/version history features work as expected. Troubleshooting already performed: OneDrive reset and re-linked SharePoint library re-synced Signed out and back into both Office and OneDrive Removed Microsoft credentials from macOS Keychain and re-authenticated Recreated local OneDrive sync relationships Verified OneDrive File Provider extensions are enabled Verified Office applications and OneDrive are fully up to date Tested with newly created files and existing files Tested "Always Keep on This Device" with no change in behavior The issue appears to be specific to the Finder-to-Office launch path after upgrading to macOS Tahoe 26.6. Before upgrading to macOS Tahoe 26.6, opening the same SharePoint-synchronized files directly from Finder correctly preserved cloud document identity and AutoSave was enabled as expected. I discussed this issue in detail with Apple Support, but they quickly dismissed it, saying that the problem is not on Apple's side and that I should contact Microsoft instead.Braille Translator Challenge
Using the Braille Alphabet lookup table provided: Part 1 - convert the given phrase from Braille to words. Part 2 - convert the given phrase from words to Braille. ✅ Solutions should be in the form of a single-cell formula. ✅ Generalized Lambda functions are welcome, provided the function definitions are included with your solution. ✅ Keep in mind, the "best" solution is not necessarily the shortest... Strive for conciseness, if you wish; just don't let your solutions be ordinary. 😉 Good luck and have fun!
