Search results

Hello JulieVDM, Based on your detailed requirements, here's a comprehensive VBA macro that automates the formatting process you've described. Please ensure that your data starts from row 3, with headers in row 3 and data from row 4 onwards. Also, back up your workbook before running the macro...

Hello Adg322, You’re definitely not alone in feeling that way, it is frustrating doing it manually! The best approach here is to use a web scraping tool like Power Query in Excel or Python with BeautifulSoup. For a no-code option, Power Query can pull structured data directly into Excel if the...

Hello Bart Van Hout, The previous formula using LOOKUP returns the highest matching score below or equal to the time, which causes incorrect scoring for cases like 3'11" or 4'16", as it doesn't shift down to the next row when there's no exact match. Revised Formula for G2 (score): =IF(C2="J"...

Hello Gary Thornton, Thank you for the follow-up and for sharing your formulas! You can nest your logic inside an additional IF that checks the final outcome to suppress zero or negative results. Here's how you can modify your formulas: Your Formula...

Hello User_2025, Welcome to the world of Excel VBA! It’s great that you're focusing on the fundamentals while avoiding common pitfalls, a solid approach. Here’s a quick breakdown of your questions: 1. Difference between a Sub and a Function in VBA: A Sub (Subroutine) performs an action but...

Hello SGustaveson, Hi there! You're doing a great job organizing the score sheets, and automating this in Excel is doable and can save tons of time! To make your process smoother and formulas more reliable, I highly recommend updating the sign-up sheet format just a bit. Specifically: Split...

Hello Gary Thornton To suppress zero and negative results in your spreadsheet, you can use an IF formula like this: =IF(A1<=0, "", A1) This formula checks if the value is zero or negative; if it is, the cell is left blank (""); otherwise, it displays the original value. You can apply this...

Hello Ehunt256, To insert these marks, you have two easy options:

Hello Ehunt26, Simplify with a Checklist Logic. Let’s start small and build: Step 1: Create Your Inventory Table (Inventory Sheet) Let’s assume: Column A: Serial Number (SN) Column B: Item Name Column C: Status (Check-out or Check-in) Column D: Last Action Time Step 2: On the Log Sheet...

Hello Ehunt256, As mentioned earlier, your system can be built using formulas (no code) or VBA macros (automation). Since you’re focused on the formula-based approach right now, here’s a full guide on where to place the formulas, plus helpful learning links so you can explore and build at your...

Hello Bart Van Hout, Because your "time" in Boys and Girls sheets is stored like "3'10" (minute' second format), you first need to convert it to total seconds so that you can compare. In the "Boys" sheet: Insert a new helper column C next to "Time (boys)". Formula in C2...

Hello Ehunt256, No need to apologize at all, your curiosity and progress are awesome, and I’m really glad to help you along the way! You're right, the earlier replies include both formulas (for a no-code setup) and VBA (for automation via macro buttons). You can start with formulas, and later...

Hello Ehunt256, Thank you again for the update and for sharing your screenshot. Your workbook is coming together beautifully! To clarify your last question: In my earlier response, I focused only on formula-based solutions, no VBA was included. The intent was to help you get started without...

Hello Ehunt256, Welcome to the ExcelDemy community! Thank you for explaining your situation clearly, no need to apologize, we're all here to learn and help each other out. You're on a great path with your idea for a barcode/QR code-based check-in/check-out system. Excel can definitely support...

You are most welcome. Glad to know that your tables and formulas working. Keep exploring Excel with ExcelDemy and keep helping each other.

Hello Lisa, Thank you for your kind words, and I’m glad to hear the tracker has been helpful so far! I’ve reviewed your latest concerns. Here’s a breakdown and solution for each point: 1. Updating for Years beyond 2025 (March 3rd falling on a Monday): You're absolutely right, the sheet was...

Hello Ezekiel, I understand your concern about minimizing helper columns, especially when dealing with large datasets. To calculate the total margin without relying on helper columns, you can use the SUMPRODUCT function combined with VLOOKUP. Here's how you can do it: Column A contains the...

Hello Isukpong Sunday, Thanks for sharing your file. It's clear you're doing meaningful work, and your Excel design already has a strong foundation. After reviewing your workbook, here’s a tailored response to help you move forward using Excel effectively without jumping straight into expensive...

Hi Maps, Thank you for your detailed follow-up. I understand it can feel overwhelming when the formula doesn't behave as expected, especially when you're applying it monthly and trying to track deductions linked to values in Column A. Updated Formula: Try this formula in your deduction...