Recent Discussions
Deep Dive into Microsoft Lists Advanced Formatting and Automation
Microsoft Lists has quickly become a powerful tool for teams who want to organize, track, and collaborate on information in a structured way. While many users are comfortable with the basics—creating lists, applying filters, and sharing with teammates—there’s a whole world of advanced formatting and automation that can take your Lists experience to the next level. In this post, we’ll explore how you can transform your Lists into interactive, visually engaging, and automated solutions using advanced JSON formatting and Power Automate. https://dellenny.com/deep-dive-into-microsoft-lists-advanced-formatting-and-automation/
Excel Formula Help
Hi everyone again, so I am trying to pull data from one tab (DATA) to another tab (MRD ABC123, SLRD ABC123, etc..) there are examples in the first 2 tabs (MRD & SLRD ABC123) of how i am trying to pull this data over. I have tried formulas and have had some help on here as well to try some formulas but nothing is wanting to work. The data on the DATA tab is being copied and pasted from a Microsoft Forms. the columns i want to transfer the data to their perspective tabs is in Orange (Column F - R) Any help on this would be greatly appreciated. I have attached the spreadsheet below
Microsoft Entra Connect sync stopped, request upgrade and library not found
Hello, I have the latest (for our company, present on Entra blade) version of Microsoft Entra Connect Sync: 4 days ago I noticed on Synchronization Service Manager that there is no sync of data; I have started the Microsoft Entra Connect Sync and found a big button with "Upgrade" word; I tried to execute the upgrade but when the it arrives to the Connect to Microsoft Entra ID step, I fill with my global administrator account but found a stop error: An error occured while retrieving the Active Directory schema. The error was: Could not load file or assembly 'file:///C:\Program Files\Microsoft Azure AD Sync\Bin\Microsoft.IdentityModel.Clients.ActiveDirectory.dll' or one of its dependencies. The system cannot find the file specified. and when I click again on Next I have the same request of global administrator user and password and the same error. Now, the library is not present but I verified, in a test tenant where I have a working Entra Connect Sync system, that the files is not present even there (and also when I start Microsoft Connect Entra Sync I haven't the upgrade button there); I also tried to repair the installation, but obviously the file is no there. What can I do? Are there other people with the same issue? Any idea is appreciated.
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.WinFix Toolkit (All Windows 10 & 11 Repair Tools in One Excel)
After I published this small information tool (Excel (365 & 2016) with network information), several people contacted me and asked if I had a tool with Excel for general service tasks that, while available in Windows, are a bit scattered and confusing. So, I've prepared this small tool for Service Level 1, with most of the service options included. Hardware Repair Tools Repair Action Label Description Reset Windows Update Components UpdateReset Stops related services, renames cache folders, restarts services. Check System File Integrity (sfc /scannow) SFC Scans and repairs corrupted system files. Check Disk for Errors (chkdsk /f /r) CHKDSK Scans hard drive sectors and attempts repair. DISM Health Restore (dism /online /cleanup-image /restorehealth) DISM Repairs Windows image and component store. Network Reset (netsh int ip reset, netsh winsock reset) NetReset Resets TCP/IP and Winsock catalog. Flush DNS Cache (ipconfig /flushdns) DNSFlush Clears DNS resolver cache. Device Manager (open) DevMgr Opens Device Manager for hardware inspection. Software Repair Tools (examples) Repair Action Label Description Microsoft Office Quick Repair OfficeRepair Launches Office repair tool (Quick or Online). Reset Microsoft Store StoreReset Runs wsreset.exe to reset Store cache. Repair OneDrive OneDriveReset Resets OneDrive client (onedrive.exe /reset). Windows Defender Full Scan DefenderScan Triggers Windows Defender antivirus scan. Reset Windows Firewall FirewallReset Restores default firewall rules. Reset Windows Search Index SearchReset Rebuilds Windows search index. Clear Temp Files TempClean Deletes temporary files and folders. Reinstall UWP Apps (if broken) AppsReinstall Re-registers all built-in Store apps. I hope it might be helpful to some people. The tool has been tested, but it could still use some improvements, so I'd like to ask everyone who has looked at or used this tool for feedback. I would appreciate any constructive feedback or additional suggestions. Happy Excel-ing! *My tool are voluntary and without guarantee! NikolinoDE I know I don't know anything (Socrates)
Finding Possible Matches to a Solution
Hello Everyone, I'm wondering if anyone has any tricks or formulas that I can use to find any possible combination of numbers that will create the desired solutions I'm looking for. Take a look at the picture I uploaded for reference. If I have a list of data in column A, I will be looking for a given set of numbers that will create a sum that matches column C. I'm looking for a trick or formula that will return all possible combination of numbers that will sum up to equal Column C and then return those possible combinations in another column for me to see (for example like what you see in columns E, F, & G). Does anyone have any ideas on how or if this can be done? I would like to do this without the use of complicated macros or other codes if possible.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.Microsoft 365 Security Made Simple What Non-IT Teams Must Know
In today’s workplace, Microsoft 365 (M365) is more than just Word, Excel, and Outlook—it’s the backbone of collaboration, communication, and productivity. But with that convenience comes risk. Cybercriminals know how much sensitive data flows through M365, making it a prime target for phishing, ransomware, and data theft. The good news? You don’t need to be in IT to play a big role in keeping your organization secure. Here’s what every non-technical team member should know. https://dellenny.com/microsoft-365-security-made-simple-what-non-it-teams-must-know/Using Microsoft 365 for Law Firms and Compliance-Heavy Industries
n highly regulated industries like legal services, finance, and healthcare, the ability to safeguard sensitive information while maintaining efficiency is not optional—it’s essential. For law firms, this balance can be particularly challenging. Attorneys need instant access to client files, but they also must ensure strict compliance with professional and regulatory standards such as GDPR, HIPAA, and SOC 2. Microsoft 365 (M365) provides a powerful suite of tools that help law firms and compliance-heavy organizations modernize their operations while maintaining a strong compliance posture. https://dellenny.com/using-microsoft-365-for-law-firms-and-compliance-heavy-industries/Transforming Remote Healthcare Collaboration with Microsoft 365
In today’s rapidly evolving healthcare environment, collaboration and secure communication are more critical than ever. Remote healthcare, telemedicine, and distributed care teams require tools that enable seamless interaction without compromising on compliance or patient privacy. This is where Microsoft 365 (M365) steps in as a game-changer for healthcare organizations. https://dellenny.com/transforming-remote-healthcare-collaboration-with-microsoft-365/
XLOOKUP returning #N/A for some values when the values are there
I am trying to use XLOOKUP to find an identifying number from a separate spreadsheet, referenced by a different identifying number. My equation works for the most part, but I have a few #N/A errors (3 out of 11), but I have confirmed that the values were present in the array and that there were no typos. I cannot share a screenshot, so I will give a simplified version using sheets WS1, WS2, and WS3 with values ID1 and ID2. WS1 is the active sheet I am writing the formula in ID1 =VLOOKUP(A2,WS2,ID1Column,false (This equation works with no issues) ID2 = XLOOKUP(ID1Value,WS2LookupArray,WS2ReturnArray) ID2 equation works for the majority of the time, but returns a few #N/A and I cannot figure out why. I have run trim to eliminate any extra spaces, I formatted all cells the same way, I have no idea why I cannot get the error cells to work.Unformatting Header/Tables on WORD after Updated Build 2508
Unformatting Header/Tables on WORD after Updated to Microsoft® Word for Microsoft 365 MSO (Version 2508 Build 16.0.19127.20192) 64-bit (Current Channel) with OS Windows 11 Pro Version 10.0.26100 Build 26100 Hi Community, I am writing to you today regarding a critical and widespread issue that is currently paralyzing our operations. Over the past two weeks, all of our Microsoft Word documents, including those created as far back as 2014, are displaying significant unformatting problems across every machine in our company. This issue affects our entire document repository and prevents us from reliably converting documents to PDF for our clients, since then we have been manually formatting the headers, tables, with the help of a feature called Gridlines. We have performed extensive internal troubleshooting and have been unable to resolve the issue. Our tests show that this problem is not present in previous versions of the software. We have isolated the issue to our current operating environment, as it affects all user profiles and machines uniformly.Emails from our custom domain ends up in quarantine
Hello, I have an issue with emails coming from one of our custom domains being detected as phishing for identity theft reason. We've got the main domain on Microsoft 365, let's call it: "domain-example.com" and the second domain on IONOS : "domainexample.com" When we receive emails from this second domain it is detected as phishing since it is a domain name very close to our main domain, therefore those emails are placed into quarantine. How do I resolve this issue? Can I indicate Microsoft 365 that this second domain is owned by our company, therefore the emails coming from this domain aren't identity theft attempts? I found how to add a domain on Microsoft 365 Admin Center but I don't know what are the consequences of this action, I want to keep my domain on IONOS and send emails from their web server. All I want is to stop emails from our company to end up into quarantine or spam folder. Thank you.How to Be an Excel Detective: Finding and Highlighting Formulas
Hi everyone, I recently wrote a blog post on some simple, yet powerful, techniques for anyone who works with Excel spreadsheets, especially those with complex data. I wanted to share a summary of it with this community, as it might be helpful to others who are looking to understand and protect their work. The post covers two main things: Quickly Revealing All Formulas: A simple keyboard shortcut (Ctrl + `) or the "Show Formulas" option can instantly reveal all formulas in a worksheet. This is a great way to quickly see how a spreadsheet is structured. Permanently Highlighting Formulas: The article shows how to use the "Find & Select" > "Formulas" feature to select all cells containing formulas and then permanently highlight them with a fill color. This visual cue can help prevent accidental edits and protect your data. Watch This in Action: For a step-by-step guide on how to use these techniques, you can watch the video on my https://www.youtube.com/@BIGurus. 🔗 https://youtu.be/1x-1dbqlWXk You can also read the full article here: https://medium.com/@anandsharad/how-to-be-an-excel-detective-finding-and-highlighting-formulas-fe9d4fdbc1b1 I'd be happy to answer any questions you have or discuss other Excel tips and tricks in the comments!OneDrive vs SharePoint
In the world of Microsoft 365, both OneDrive and SharePoint serve as robust platforms for file storage and collaboration. Yet, understanding which one fits your specific needs can be challenging. This blog explores their key differences, practical use cases, and offers guidance to help you make the right choice. What Is OneDrive? OneDrive for Business functions as a user-specific cloud repository within the Microsoft 365 framework, optimized for individual file storage, synchronization, and personal document management. What Is SharePoint? SharePoint Online operates as a collaborative content management and intranet platform within Microsoft 365, engineered for structured data handling, enterprise-level document sharing, and workflow automation across teams and departments.Leaving a blank space
I am using Vlookup to find data on a different tab of an excel sheet. If there something I can put in the Vlookup formula to show a blank space in place of a "#N/A" if there is no data in the cell it is trying to look up? Example below - the vlookup formula is in the 3rd column. since there is no data in the 2nd column, i would like the 3rd column to be blank instead of showing the #N/A W 1424 BIRKDALE 8 TH 1450 ROUND MEADOW 8 F 1450 ROUND MEADOW 7 SAT #N/A
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
