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! 🙂
Having trouble with IF formula
Hello, I'm not sure what's going on with my formula, but it is supposed to double the "Grip" when a checkbox is checked. All the numbers being pulled from tables are correct and when not checked the "Grip" adds up correctly. When doubled, it is also adding the "Wall Thk." number an extra time. Correct single Grip = 1.625" Correct double Grip = 3.25" I get 3.5" for double grip. Formula used below, as well as pictures. If my formula is wrong, then I can't see it, but it has to be adding T8 somehow. =IF(X8,((INDEX(DATA_THK,MATCH(1,(Flg_Thk[Spec.]=N8)*(Flg_Thk[Series]=O8)*(Flg_Thk[Class]=P8)*(Size=Q8),0),MATCH(R8,FLG_TYPE,0))+T8*(R8="Lap Joint (LJ)")+V8*(U8="RF"))*2),(INDEX(DATA_THK,MATCH(1,(Flg_Thk[Spec.]=N8)*(Flg_Thk[Series]=O8)*(Flg_Thk[Class]=P8)*(Size=Q8),0),MATCH(R8,FLG_TYPE, 0))))+T8*(R8="Lap Joint (LJ)")+V8*(U8="RF")
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-bit
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.
📣 ExcelAt40 – Days 5 to 10 Recap
Hello Excel Community 👋 I’ve been running a daily series called #ExcelAt40, celebrating 40 years of Microsoft Excel through stories, innovations, and personal reflections. Here’s a recap of Days 5 to 10 — each post dives into a pivotal moment in Excel’s evolution: Day 5: Charting the Future Before dashboards ruled the world, Excel gave us the power to visualize data with clarity https://www.linkedin.com/posts/olufemi-olamoyegun_excelat40-day-5-charting-the-future-activity-7364386306572828673-dpj8 🧠 Day 6: Formulas That Changed Everything From =SUM() to =XLOOKUP, Excel taught us how to reason with logic. https://www.linkedin.com/posts/olufemi-olamoyegun_excelat40-formulas-that-changed-everything-activity-7364968873474908161-PGNb 📈 Day 7: PivotTables Debut Celebrating Professor Pito Salas, the visionary behind dynamic data analysis. https://www.linkedin.com/posts/olufemi-olamoyegun_day-7-pivottables-debut-activity-7366077860282896384-euqr 🧬 Day 8: VBA Rises In 1997, Excel unlocked automation with Visual Basic for Applications. https://www.linkedin.com/posts/olufemi-olamoyegun_excelat40-day-8-vba-rises-activity-7366342708942008320-yJL7 🧩 Day 9: The Ribbon UI Revolution Excel 2007 introduced the Ribbon a bold redesign that changed how we work. https://www.linkedin.com/posts/olufemi-olamoyegun_day-9-the-ribbon-ui-revolution-activity-7367783381973053440-I-KK 🛡️ Day 10: Y2K Audits Excel’s role in averting global disaster during the Y2K crisis. https://www.linkedin.com/posts/olufemi-olamoyegun_y2k-audits-activity-7367795370120187904-5ewY I will love to hear your thoughts: 💬 Which Excel feature changed the way you work? 📌 What’s your favorite moment in spreadsheet history? Let’s celebrate the legacy together. #ExcelAt40 #MicrosoftExcel #OlufemiBuilds #NoCode #TechLegacy #ExcelCommunityApplying a Border via Conditional Formatting
Hello All Excelers, On a worksheet in Column A I have a set of names, in Column B have a set of dates, and in Column C I have a set of values. The values in Column C have some Conditional Formatting (CF) to indicate the highest 3 values. The CF will make a red boarder around the cell, and make the interior cell color blue. I want to make a CF (or anything else) that would make a red boarder and interior cell color blue for the rows in Columns A and B. Any ideas? Thanks GiGi
Formula Challenge: The most efficient way to generate a Number Spiral (Ulam spiral) ?
The goal: Ulam spiral - Wikipedia The trick is creating a function capable of producing the largest matrix of numbers possible (this may rule out the recursive approach). The approach I took: The approach I took was creating 'frames' and working inward with REDUCE essentially performing repeated addition: REDUCE works its way through an array of odd numbers in descending order (1 is omitted) with 3 different situations: 1. The odd number is the largest so the matrix does not require padding. 2. The odd number is 3, the anomaly, so a 'padded core' is created. 3. The odd number is not the greatest nor 3 so a padded matrix is generated Spiral Lambda: =LET( s, ODD(INT(SQRT(n))), arr, UNIQUE(ODD(SEQUENCE(s - 1, , s, -1))), arrCore, {5, 4, 3; 6, 1, 2; 7, 8, 9}, IFERROR( REDUCE( 0, arr, LAMBDA(a, v, LET( TopBottomPadding, EXPAND(0, (s - v) / 2, s, 0), SidePadding, EXPAND(0, v, (s - v) / 2, 0), top, SEQUENCE(, v, (v - 1) ^ 2 + 1, -1), bottom, SEQUENCE(, v, (v - 1) ^ 2 + v, 1), left_frame, EXPAND(SEQUENCE(v - 2, , (v - 1) ^ 2 + 2), , v - 1, 0), right_frame, SEQUENCE(v - 2, , (v - 1) ^ 2 - (v - 1), -1), core_stuffing, EXPAND(0, v, (s - v) / 2, 0), core, VSTACK( TopBottomPadding, HSTACK(core_stuffing, arrCore, core_stuffing), TopBottomPadding ), center, HSTACK(left_frame, right_frame), nopad, VSTACK(top, center, bottom), pad, VSTACK( TopBottomPadding, HSTACK(SidePadding, VSTACK(top, center, bottom), SidePadding), TopBottomPadding ), a + IF(v = s, nopad, IF(v = 3, core, pad)) ) ) ), "Please enter a number 17 or greater" ) ) The accuracy checks The highest number I've been able to get away with for n is 300,001. I'm interesting in any suggested improvements or different approaches to this task!
Power Query Error Data Not Loading
I’m using Office LTSC 2024, In Power Query, when I try to load data from another Excel file (or even the same workbook), I get the error: "Microsoft Excel couldn't load a necessary component. It might have been damaged or deleted. Try reinstalling the client software or data source driver software for your database." And also: "download failed error in data source query n connections". Here’s what I’ve already tried: Tested with a new blank workbook, same error appears. Done Office repair (both offline and online), still not working. The issue is only with Power Query loading Excel workbooks. Could anyone please help me with this issue?
Excel Find and Replace Box
When I hit CTRL+F in Excel now, the search box is popping up as a full sized window, that covers the whole screen, so I have to minimize or close it to see the whole sheet again. It used to just open up in the small window that you could move around. To make it more fun, it doesn't happen every time. Just most times. There has to be a simple setting for this somewhere. Any help would be much appreciated. Thanks, John
