Pinned Posts
Forum Widgets
Latest Discussions
Formula 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.
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 & 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! 🙂
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
How 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.Excel For Web: "Picture > Place In Cell" is Gone
Hi, I have Excel for the web. A few months ago, when I was using Excel for the web, the Insert > Pictures > Place In Cell option became no longer available on my Windows 11 laptop. I don't think it has anything to do with any new updates to Excel for the web, as I'm able to use Place In Cell on my iPhone (where none of my desktop images are stored). Here is a reference of what I'm trying to do: https://www.youtube.com/shorts/V0tX83Zm-kY?feature=share How can I update my excel for the web to return it to it's original settings, allowing me to use the place picture in cell feature?Extract data using text within set of data
Hi i have a set of data with keywords containing SLS1,SLS2,SLS3....SLS10, ULS1,ULS2....ULS10. i wish to segregate this into separate set of SLS and ULS using certain condition like max axial. For ex. cell P8 should return the max axial value out of load case under column 'C' wherever the load has substring "SLS" in it.
