Recent Discussions
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!Solved59Views0likes2CommentsMy 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?45Views0likes4CommentsFormula 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.27Views0likes1CommentStandard 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. Aaron19KViews2likes5CommentsExcel (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! 🙂138Views0likes11CommentsWhat 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/8Views0likes0CommentsAvoiding 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/10Views0likes0CommentsCommon 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/9Views0likes0CommentsHighlight or Change the font color for only a specific word and not the entire cell in Excel?
Hi there. This is my first post, and I hope someone can help me. I have a large spreadsheet I need to look through to find specific keywords and either highlight those keywords or change the font color so they draw the reader's attention. I am unable to figure out how to do this automatically without highlighting the entire cell. Each cell has multiple lines of text, so I do not want to try to read through each cell to find the one word or key phrase to highlight or change the font size on my own. I need this to be an automatic action. Any takers out there willing to give me a hand? Thanks in advance.Solved123KViews1like12CommentsExcelAt40 – 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 #ExcelAt4015Views0likes0CommentsMove cursor within Edit Formatting Rule
Hi, I apologies if my attempt to search for an answer was using the wrong key words, as it seems an obvious question to have been answered before. I am trying to edit a Conditional Format which uses a formula (Edit Formatting Rule - Use a formula to determine which cells to format > Edit the Rule Description > Format values where this formula is true). I can use my mouse to insert the cursor at a point in the formula, but how do I move the cursor WITHOUT IT INSERTING THE CELL REFERENCE? I know it must be possible, as I have inadvertently achieved it, I think by perhaps highlighting and deleting a word before moving the cursor. What I (anyone?) needs to do, is switch between moving the cursor, and choosing to insert a cell reference. If I can't switch between the two modes, I would much rather move my cursor in preference, and I will manually insert the cell references.Solved9.4KViews1like4CommentsError installing Apps 365, command not supported.
I was performing an Online Repair for a user. It did the uninstall fine, but then threw this error. I tried to reinstall, same error. Used the MS Cleanup tool, ran SFC, cleared temp files, cache... Internet connection is stable. Disabled security software (Zscaler). I'm out of ideas. I'm hoping someone has seen this before. Thanks for any help!Solved46Views0likes2CommentsHow to resolve formula discrepancy Excel/SharePoint
Good afternoon, could someone help me? The formula =IF(ISERROR(INDEX(Form1!F:F, ROW()-90)), "", IF(INDEX(Form1!F:F, ROW()-90) = "", "", INDEX(Form1!F:F, ROW()-90))) works in offline Excel, but in SharePoint/Excel Online it shows an error. It appears there is an error in the formula. I am using Portuguese in both versions.94Views0likes5CommentsCant access admin panel
Hi Everyone, I have done something really silly and I don't mind if I get a laugh or two, I have locked myself out of our two admin accounts due to both had 2FA on and the phone that the notifications went to sadly has been reformated without the person checking with me first, I have an E5 Licence but without being able to access the admin page I can't access support to get this resolved 😞 - I'm kind of stuck and at the moment even though we only have a few licenses (mix of E5and F3) Feeling really silly about this but if anyone has an idea of how I can resolve this I would be really grateful Joe837Views0likes3CommentsHow can I sync audio with my handwritten or typed notes in OneNote
Hello, I have a habit of taking audio notes while writing, I'm looking a way to record audio notes during lectures and have it line up with my notes, so I can tap on a note and hear what was said at that exact moment. Does OneNote support this?56Views0likes5Comments
Events
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, 202586Views1like1Comment
- Customers in Austria now have new options for managing the location of their Microsoft 365 data.Sep 02, 2025140Views0likes0Comments