Search results

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...

Hello Maps, You can use the following formula. =IF(OR(A33="",A33=0), "", IF(A33=-100, 0, IFERROR( VLOOKUP(A33,$A$3:$C$11,3,TRUE) + (A33 - VLOOKUP(A33,$A$3:$C$11,3,TRUE)) * VLOOKUP(A33,$A$3:$D$20,4,TRUE), "" ) ) ) Explanation...

You are most welcome. Keep Exploring Excel with ExcelDemy. Keep helping each other to make this community stronger.

Hello Shminhas, Use the following formula: =SUM(IF(ISNUMBER(SEARCH("Kg",A1:A5)), --SUBSTITUTE(A1:A5," Kg",""), 0))

Hello Shminhas, If your range contains some cells with "Kg" and others with "NA" or other non-numeric text, you need to modify the formula to ignore non-numeric values while summing only the cells that contain "Kg". Use the following SUMPRODUCT formula to only sum values that contain "Kg"...

Hello Shminhas, The formula you have used from our article is correct: =SUM(SUBSTITUTE(D5:D9," Kg","")+0) However, you're getting a #VALUE! error because this formula needs to be entered as an array formula or modified to work correctly with array inputs. The standard SUBSTITUTE() function...

Haha! Glad you got it working! Sometimes, it's just that one little tweak that makes all the difference. And hey, explaining Excel to a Luddite is a heroic effort in itself—props to you for trying! Happy Excelling with ExcelDemy!

Hello, It looks like the issue is likely related to one of these common problems: Cell Width Too Small: If the column isn't wide enough, Excel will display #####. Try expanding the column width. Incorrect Formula or Reference: Ensure you're using the correct formula, like: =A1 / 86400 +...

You're very welcome! 😊 I'm glad the confirmation helped you pinpoint the issue. The number vs. text mismatch can be a sneaky problem, but now you’ve got it sorted! If you run into anything else, feel free to ask—happy to help. Let’s keep helping each other and make the ExcelDemy forum a...