Recent Discussions
Looking up specific period financials from multiple period worksheet
Hello, I have the following sample data: The data from Column I onwards is in a different worksheet in the layout that you see above. I need to be able to bring in the July data as shown from Cols C to E. One easy way would be to concatenate the month with the Sector and Currency headings in rows 3 & 4. For example, JulyADRUSD and then do a nested xlookup to bring in July ADR USD Accounts Receivable information. However this would mean creating a new row for my concat field. Is there any other way we can fetch the required information? Hope you can point me in the right direction. Thank you.
ExcelAt40 – Day 11: Lookup Wars – VLOOKUP vs XLOOKUP
Hello Excel fam 👋 Today’s post dives into the differences between VLOOKUP and XLOOKUP — with a visual comparison, practical tips, and even a quiz to test your lookup knowledge. We also covered how to use XLOOKUP with IFERROR for cleaner formulas and wrapped it all up with a cheat sheet. Would love to hear: 👉 Are you still using VLOOKUP? 👉 What’s your favorite XLOOKUP trick? #ExcelTips #ExcelCommunity #LookupFunctions #OlufemiBuilds #ExcelAt40Microsoft Word does not save fonts after exporting a document to PDF
I have encountered such a problem that when saving a document in PDF format or using the Adobe Acrobat Pro plugin, I simply do not save fonts or their font styles. All fonts are installed for all users, everything worked fine before reinstalling the system. I tried embedding all fonts in the file through the Word settings. I've tried everything-all the PDF export settings — nothing helps.
Best way to get rolling 12-month totals
I am using Excel for Mac version 16.102. I have data in a Table which is basically date, category & value. There are many other columns I use for filtering. I pivot this data to get totals by month within year but I hide the yearly totals and just have the grand total. My pivot table is filtered to include\remove high-level category data. I have a Timeline which allows me to select the date range of my pivot. I have a number of slicers to facilitate filtering to get the dataset totals I need. There maybe a better way but the above works. My ask is how do I go from the above to easily get a rolling 12-month totals for say Jan 24 - Dec 24, Feb 24 - Jan 25, Mar 24 - Feb 25 etc etc? I can move the timeline which gives me the correct answer but I'd like to be able to see the rolling totals for the last 12-months at a glance without having to keep moving the timeline. Eventually I'd like to graph the last 12-months so I can see movement over time. Can I do want I want with a pivotable or do I need another approach? Thank you for your help.
SUMIF help
Trying to create a total based on 2 pivot tables. What formula do I put in the column in red text. PIVOT #1 ITEM SUM APPLES 5.2 PEARS 3.2 CHERRY 0.4 TOAST 0.2 ORANGE 1.8 WATER 0.4 LIME 2.5 PIVOT#2 ITEM: SUM PEARS 1.8 BERRY 0.7 PEACH 1.4 KIWI 1.4 WHAT FORMULA DO YOU PUT IN SO THAT IT WILL SEARCH MATCHING 1ST COLUMN AND ADD TOTALS FROM BOTH PIVOTS TO THIS 3RD LIST. ITEM: TOTAL (PIVOT #1 AND #2) THAT MATCH ITEM APPLES PEARS CHERRY TOAST ORANGE WATER MUSHROOM KIWI
Macros crashed Word, then disappeared, now back again but not working
My problem started with a few macros in Word (Office 365) crashing Word, then the list macros, while still showing up with Alt+F8, disappeared from VBA. I played around with templates and such, and now have the VBA showing the whole list of macro scripts. However, there is a red scroll icon on my macros list and I have had the message "Your organizations administrator turned off the service required to use this feature", which is odd because I am the administrator (this is a home Office 365 subscription). So I can see the macros in VBA but I can't run any of them, nor can I create any new macros. How do I get my macros up and running again? (I tried to 'repair' Office, and after the full repair ended up with a version of Word that isn't as customised as it used to be.) And what might be the cause of this problem?Word on iPhone
In the past, I’ve managed to edit some documents on my iPhone in Microsoft Word. But now Microsoft is slapping me in the face with grammatical suggestions that obscure my document. I don’t want any grammatical suggestions, but I can’t figure out how to make them stop. Can anybody suggest how I can do that? Am I in the right place to ask this question? Is there another place for the iPhone app?
Avery Word Template – Text Boxes Not Linked, But Typing in One Moves Content in Others
Hello, I’m helping a client who has been using a Word document with an Avery name tag template for years. Recently, she noticed some unusual behavior: The document is built with multiple text boxes laid out for name tags. The text boxes are not linked (we checked, no “create link/break link” settings). However, when she types in one text box, the content in other text boxes shifts around or moves. It’s not duplicating the text, but it’s disrupting the alignment/layout of all the tags on the page. This happens even with brand new text boxes created in this document on her computer. If we create a brand new document with text boxes on a different computer, it works normally. But once that file is opened on her computer, the same issue occurs again. So far we’ve tried: Resetting Word settings (renaming Normal.dotm and Word registry keys). Testing with a new blank document. Checking for linked text boxes. Saving as a new file/template. The problem seems isolated to this one computer/Word installation, but it affects both old and new documents once they’re opened here. Other computer with the same template doesn't do this. Has anyone seen this before? Any advice on what else we can try, or how to ensure her Avery templates work normally again, would be greatly appreciated. Thank you! Cheers! - ColinSEQUENCE formula with curly brackets
I have this simple formula, it works as expected up until the SEQUENCE part : In short rws would equal to 32, and srt to 1 I expected this to output the same as SEQUENCE(32,1,1,1), but it outputs just a single 1 I did check the evaluation process of the formula and it seems like this instead makes SEQUENCE({32},1,{1},1), and that, in a new cell does outputs the same single 1 What is it that i'm missing? Is it because of the LET function? Is there any fix to this? Thank you in advance! =LET( x,E1:E2288, y,SEQUENCE(ROWS(x)), z,FILTER(y,x=""), str,VALUE(INDEX(z,G1)), rws,VALUE(INDEX(z,G1+1)-str), SEQUENCE(rws,1,str,1) )Introducing Knowledge Agent in SharePoint (Public Preview)
In September 2025, Microsoft launched the Knowledge Agent feature in public preview for SharePoint, as part of the broader Copilot & AI investments. This marks a significant step toward making SharePoint not just a content repository but a more intelligent, AI-aware knowledge system. https://dellenny.com/introducing-knowledge-agent-in-sharepoint-public-preview/max corresponding to a value which may be in 1 or multiple sets
Hi G6 is showing error because F6 is not found in D15:D50. what would be the simple process that F6 is searched in D15:D50 and D56:D91 and returns value from col K instead of an error whether or not that value exist in either of the sets.How to Migrate from Facebook Workplace to Microsoft Viva
As businesses evolve, the need for a more integrated, secure, and Ahttps://dellenny.com/how-to-migrate-from-facebook-workplace-to-microsoft-viva/I-powered digital workplace grows. Many organizations that initially adopted Facebook Workplace are now considering Microsoft Viva, a modern employee experience platform designed to work seamlessly within Microsoft 365. If you’re planning to migrate from Facebook Workplace to Microsoft Viva, this guide will help you navigate the process smoothly.Outlook group contact reappearing after removal
One of my users has an Outlook group with 15-20 contacts in it. A terminated user's email address refuses to be removed causing email bounce backs. When removed from the group and refreshed the contact reappears after changes were saved. Keep in mind that other contacts have been added and removed without issue. I have attempted to remove the user via desktop app and OWA. Cleared web cache, cookies, etc. Account has also been fully deleted from 365 at this point yet the contact remains. How do I banish this contact?Rack of Lambda
There’s been a lot of content shared recently to commemorate the upcoming 40th anniversary of Microsoft Excel. Personally, I’ve only been using Excel for around half that time, but October also marks my 2-year anniversary since "joining the conversation" on this forum. As a gift from me to you (anyone interested), I’ve spent some time over the past few weeks revisiting old posts, updating methods I shared previously and packaging them into a collection of generalized Lambda functions to assist with a variety of common array manipulation and transformation scenarios. The attached file contains some 35+ Lambda functions, ranging from very simple concepts to much more advanced techniques. You can also import them directly from my gist, if desired. While they were all compiled and composed of my own accord, I would be remiss if I failed to credit the community and its members as a major resource in my own development. The amount of knowledge, tips and tricks gained through community collaboration is simply invaluable. You may notice some recurring themes in the way I’ve written many of the functions. For example, I like to keep the optional arguments as simple as possible, using either Boolean values passed to IF, or numeric options from 0 to 3 passed to CHOOSE. Also, many of the array transformation functions use TOCOL-IF-SEQUENCE in one way or another, with MOD-QUOTIENT-SEQUENCE used only a few times in the more complex algorithms (e.g. HWRAP and VWRAP). The collection also includes a few examples of Lambda recursion, the most notable being PF (Prime Factorization). CROSSJOINM was written as a "how-to" demonstration for filtering multiple optional arguments using LAMBDA and NOT-ISOMITTED. There’re also some powerful scanning functions like SCAN3, which can handle multiple input arrays, as well as EVALS with VALS2 to VALS7, which can store and recall multiple variables at each iteration (useful for corkscrew calculations). What you won’t find, however, are methods that use INDEX in an iterative manner with functions like MAKEARRAY, SCAN, etc. as these are only efficient when iterating over a range reference (they will bog down considerably and become practically unusable after just a few thousand iterations when looping over an array object). As such, I don’t recommend them as "generalized" solutions, although they can be very effective on a case-by-case basis. Similarly, you will only find 2 examples in this collection that use REDUCE-STACK in a limited capacity, with fewer than 10 iterations, as I also consider this to be a method of last resort due to its problems with efficiency when the number of iterations cannot be controlled. Hopefully one or two of them proves useful. If not, no big deal. Many of the examples in the attached file are interactive, so you can see how the different options affect the output. For those brave enough, please feel free to share your own custom functions too. I’d love to see what you got. Cheers!Unlocking Employee Potential A Complete Guide to Microsoft Viva Suite
In today’s digital-first workplace, employee engagement, well-being, and continuous learning are just as important as productivity. Microsoft Viva, an integrated employee experience platform within Microsoft 365, empowers organizations to connect, engage, and grow their teams seamlessly. Whether you’re a business leader, HR professional, or IT manager, the Viva suite offers tools to transform how your workforce collaborates and thrives. Let’s dive into its features, benefits, and how you can start using it effectively. https://dellenny.com/unlocking-employee-potential-a-complete-guide-to-microsoft-viva-suite/Microsoft Entra Suite The Future of Identity and Access Security
As organizations shift more workloads to the cloud, adopt hybrid and remote work models, and integrate multicloud environments, identity and access risk becomes a central security frontier. Traditional network perimeter defenses are no longer sufficient. Zero Trust is the guiding principle: no implicit trust, always verify, least privilege, assume breach. https://dellenny.com/microsoft-entra-suite-the-future-of-identity-and-access-security/Camera tool overlapping images
Heya, I'm having issues with the Camera tool layering the same image ontop of itself frequently, especially when re-opening the file whereby it states: This workbook contains links to one or more external sources that could be unsafe. If you trust the links, update them to get the latest data. Otherwise, you can keep working on the data you have. If I select update, it will layer a new picture on top with source formatting. If I select don't update, it will layer with current formatting. It also layers intermittently while working on the workbook, unsure if this is from a specific action... Please help!
Recent Blogs
- Formula completion autocompletes formulas when you type = by referencing the context of your workbook.Sep 26, 2025
- Whether you're a data engineer building pipelines or data analytics engineer looking to optimize your data model or data warehouse, Copilot in Microsoft Fabric is your intelligent partner for acceler...Sep 25, 2025
