Recent Discussions
Filter function with a criteria
Dear Experts, I have a data like below( in columns A/B/C) , and needed the result in column (I/J/K), but I could achieve only like in Column (E/F/G) For example for the rnti = 19453, the corr0 , at time -> 06:34:32.171912 is not there so at Row-3, the entry should be empty Attached is the worksheet, Br, Anupam
Help with formula
Hello! If I'm trying create a formula that pulls data from one sheet into another. I want it to pull in data in column E if column B has a january date AND column C has the word discover in it, into another tab within the same workbook. The formula below works perfect but the only problem is it has to be only the word "discover" (yellow cells) in the cell, if it says "discover - food" (green cells) it doesn't pull. Is there a way to have the formula pull the data if the word "discover" shows in column C but with other words like in the green cells? My current formula that kinda works: =INDEX('My ✓ing'!E:E,MATCH(1,(MONTH('My ✓ing'!B:B)=1)*('My ✓ing'!C:C="Discover"),0)) Pulling from this sheet below Into this sheet in the same workbook. The yellow ones work because it just has discover, the green is not cause it has Discover - food. Is there a way to get it to search for the word discover and not necessarily match? Thank you for any help!
Excel 365: dd-mmm-yyyy now gives Sept instead of Sep
Excel 365: dd-mmm-yyyy now gives Sept instead of Sep — that breaks the documented format standard. Who thought this was a good idea? They linked it to the Unicode locale standard. But it violates the formatting of "mmm". Work arounds for USA locale format as [$-409]dd-mmm-yyyy → 05-Sep-2025 UK locale [$-809]dd-mmm-yyyy → 05-Sep-2025 AU [$-C09]dd-mmm-yyyy → 05-Sep-2025 NZ [$-1409]dd-mmm-yyyy → 05-Sep-2025 Problem is this is not portable. PLease can someone reach out to the devs and get this reverted? Formulas trying to pick out Sep & year from the string now will break.
Excel (365 & 2016) with network information...and much more Information to Filter.
With Excel (365 & 2016) Network information, information about Local Network Connectivity, Test Connection to a Specific Web URL, WiFi SSID information ...and much more information to filter with a button. I was trying to create a tool that would allow me to filter the necessary information from all the PCs I need to work on using a USB stick. I came across an old file that I edited and added additional information to the code. I'd like to share this file (Help for self-help). If anyone finds it useful, or would like additional tips or information, please feel free to send me feedback. If it doesn't help you...just ignore it. I welcome any constructive comments. * After loading the file, be sure to activate all macros. Happy Excel-ing! 🙂Disable Direct Send in Exchange Online to Mitigate Ongoing Phishing Threats
Direct Send allows devices and applications to send unauthenticated emails over port 25 directly to Exchange Online. While this may support legacy devices like printers or scanners, it also opens the door for threat actors to deliver spoofed emails without authentication. These messages often appear to come from trusted internal sources, making them especially dangerous. To reduce your organization’s exposure to this threat, it's strongly recommended to disable Direct Send using Microsoft’s newly introduced RejectDirectSend setting. You can quickly enable this setting using PowerShell: Connect-ExchangeOnline Set-OrganizationConfig -RejectDirectSend $true If you still have devices or applications that need to send emails, use authenticated SMTP submission or set up connector-based routing with certificate or IP restrictions.
My Azure login is stuck at MFA and cannot proceed
In August, I was still able to log in to Azure, and by logging in through GitHub I could bypass 2FA. But now, no matter how I try, logging in via GitHub always requires 2FA. I can’t access my Azure account anymore—nothing works. The system prompts me to use Microsoft Authenticator to confirm a two-digit code in real time. My Microsoft Authenticator on my iPhone is logged into the same Microsoft account, but I’m not receiving any verification requests for Azure login. No matter how much I refresh, nothing shows up. I’ve already updated the Microsoft Authenticator app to the latest version from the App Store. However, my personal Microsoft account works fine and can log in without any issues.
VBA
Hello everyone, I'm new here, so please be kind! This happens every time I create a new file, and Visual Basic Editor won't open in Access. When I click on 'Visual Basic', a pop-up box appears and I'm told that the database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all codes from modules, forms and reports. You should backup your database before attempting to delete the VBA project. Note: To create a backup copy, click Cancel and then make a backup copy of your database. To open the database and delete the VBA project without creating a backup copy, click OK. Well, I have no database to read in the first place because I haven't made one, so what does it mean, and how do I fix this, please?
Macros being blocked in Excel even though file is located in trusted site
I am experiencing an issue that I have seen several discussions about, however there does not appear to be an answer so I wanted to see if anyone has found an answer for this. I have a user that is getting the following message in excel when opening a file on a network share: Microsoft has blocked macros from running because the source of this file is untrusted. I have confirmed that the file location is in the Trusted Center and in addition, this issue just started happening recently with no changes that I am aware of. I have also placed the server IP and Server name of the server in the Trusted sites under Internet Options, but this did not change the issue. Here is some info about the system: Windows 10 Pro 10.0.19045 Build 19045 Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20124) 64-bitFormula to Autofill Value Based on Another Cell
I solved part of this but not the second part. I have these three columns on a document I am working on. I need a formula to do two things: If Column I lists a frequency (Annual, Biannual, Triannual) then K will autofill the next review date based on the date in Column J. If Column I lists TBD, then Column K should also autofill with TBD. In this scenario, Column J will remain blank. The formula I have so far is =IFERROR(EDATE(J2,LOOKUP(I2,{"Annual","Biannual","Triannual"},{12,24,36})),"") (I'm using IFERROR to hide the #NA returns in the blank cells.) I can't figure out what formula to add in to return a value of TBD instead of a date if Column I is TBD.Standard Operating Procedures in OneNote - Best Method?
Hi, I've been in business for over 18 years, with 6 employees. We have over 300 policies and procedures that have been written and rewritten. They have always been stored on our Sharepoint server in a regular file folder structure that syncs to our computers. Because of it, nobody uses them for they are difficult to find. Sometimes you don't know the name of what you're looking for, other times its an SOP that could be under production or finance. The system has just never worked. I'm currently implementing a system in OneNote. I have it set up where our 9 primary areas are all tabs. There then exists sections for checklists, specific procedures, and then one large 20-30 page manual for that department that discusses in detail everything that needs to be known. An example is in the 23-page Marketing Manual, there are five paragraphs explaining what brand colors are, why they are important, and why we can't stray from them. It then has a few links to reference other documents, one of them is our Branding Sheet that is a Word document, stored inside OneNote. OneNote is also great because it's desktop software that each of our computers has, every single document can be searched at once, you can utilize links to any part that you'd like, you can utilize tags, and you can store the referenced document inside OneNote (so I don't have to deal with somebody changing the file name or somehow breaking the link to the server. I haven't released it yet, but my employees say they would use it if it were easy. As I'm slowly going through and entering the SOPs into OneNote, I'm finding minor issues with my system in OneNote The formatting is VERY limited. So making a great SOP is not as easy as it is in Word Once I have everything in there, I dont think I can get it back out in an editable fashion. I can print the .pdf but it's not like it's a Word document that can be moved around You can't really set permissions on it. I can lock pages, which would work, but I'd prefer permission on different areas Getting everything in there is going to be challenging enough, then I have to go back and link everything. Before I spend too much time organizing these SOPs and copy/pasting them into OneNote, I was hoping that somebody has gone down this road before and can either advise me away from OneNote to another product or offer advice as to why I should keep going down my path. Thanks in advance. AaronWhat to Do When SharePoint Search Doesn’t Return the Right Results
SharePoint search is one of the platform’s most powerful features—when it works as expected. But many organizations face a common frustration: search results that don’t seem accurate, complete, or relevant. If your users are struggling to find what they need, it can quickly undermine adoption and productivity. The good news? Most search issues can be diagnosed and fixed with the right approach. Here’s a practical guide to troubleshooting when SharePoint search isn’t returning the right results. https://dellenny.com/what-to-do-when-sharepoint-search-doesnt-return-the-right-results/Avoiding SharePoint Sprawl Without Killing Collaboration
SharePoint has become the backbone of collaboration for many organizations. Its flexibility is a blessing—teams can create sites, share documents, and manage projects with ease. But without governance, that same flexibility can quickly turn into SharePoint sprawl: a maze of redundant sites, duplicated files, and forgotten content that frustrates users and undermines productivity. The challenge is clear: how do you prevent sprawl without choking the collaboration SharePoint was designed to enable? Let’s break it down. https://dellenny.com/avoiding-sharepoint-sprawl-without-killing-collaboration/Common Mistakes When Upgrading from Older Office Versions to Microsoft 365
Many organizations are moving from older on-premises versions of Microsoft Office (like Office 2010, 2013, or 2016) to Microsoft 365’s cloud-based suite. The transition brings big benefits—real-time collaboration, enhanced security, and always-up-to-date apps. But without proper planning, the move can create frustration for users and headaches for IT teams. Here are some of the most common mistakes businesses make during the upgrade, and how to avoid them: https://dellenny.com/common-mistakes-when-upgrading-from-older-office-versions-to-microsoft-365/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 #ExcelAt40
Recent Blogs
- Your product will still work, but when Microsoft says a product has reached "end of support", it means the product will no longer receive: Security updates Non-security updates Bug fixes Ne...Sep 04, 2025
- Customers in Austria now have new options for managing the location of their Microsoft 365 data.Sep 02, 2025
