Search results

Hello Lisa, Great progress and thanks for sharing the exact formula and the switch from R to U. Since it’s still not calculating after widening the ranges, here are the two most common gotchas when adding Saturday: Make sure the two criteria in each SUMIFS are still matching real values in the...

Hi Lisa, I’m so glad to hear it’s working well for you and great job figuring out the year and Saturday adjustments! You’re right, adding Saturday as a new day is usually easier than adding a whole new class, since adding a new class would require updating multiple formula ranges across...

Hi Lisa! Here are the quick fixes: Extend Year list Use a dynamic list for the Year dropdown: =SEQUENCE(15,,YEAR(TODAY()),1) → auto-creates this year + next 14. Make month dates auto-fill (Year in Settings!B2, Month # in Settings!B3) =LET(y,Settings!$B$2,m,Settings!$B$3, s,DATE(y,m,1)...

Hello Ti-Paul, You’re very welcome, and great question! Yes, the formula looks for the Product No that’s in the cell you reference (in this case, $A2). So, if your Product No is in a different cell, for example, B2 or D5, you just need to change $A2 in the formula to that cell reference. For...

Hello @spring1268, Thanks for the details! Our original tutorial and sample files were created and tested on Excel 365 (Standard). Your screenshot shows Office 2019, and “custom function not recognized” in .xlsm files almost always comes down to macro loading and module placement (not a...

Hello Ti-Paul, You can total a specific Product No across multiple sheets using this formula; no VBA needed. First, list all the sheet names (except the TEST SHEET) in a range, say X2:X20, and name that range Tabs. Then use this formula in TEST SHEET!L2 (assuming the Product No is in A2)...

Hello, You can easily summarize data from your Order tab into the Order Type tab using the SUMIFS function. Use this formula in the yellow summary table (for cell C5 where Store = 1 and Category = a): =SUMIFS('Order'!C$3:C$8, 'Order'!$B$3:$B$8, C$4) Then adjust for each column (store) and row...

Hi Shivchand2002, Please explain your problem in more detail first. A screenshot of the relevant data (instead of a full file upload) will help us understand better.

You are most welcome. Glad to hear that! Happy you’re finding value in the group. Keep learning and exploring with ExcelDemy!

Hello Lee, Thanks, that makes sense. If D25:D27 should be added up (any numbers), and only when all three are 0 you want to use 50% of the Theoretical Capacity (D23 × C28), then put this in D30: =IF(SUM(D25:D27)=0, D23*C28, SUM(D25:D27)) SUM(D25:D27)=0 → no measurable ventilation ⇒ return D23...

Dear Boy282828, Thank you for letting us know, I’m glad the issue has been resolved. 😊 I’ll make sure to pass along your appreciation and kind regards for Lutfor. Your thoughtful message will surely mean a lot to him.

Hello, You can follow the following steps; Identify Home & Away Teams: In your current table, the Winner is in column F and the Loser in column H. The scores are in columns J (PtsW) and K (PtsL). To map them as Home vs Away, you need the @ indicator in column G. If @ is with the Winner, then...

Hello Lee, Here’s a one-cell solution for D10 that follows your rules: Rule logic: If no measurable ventilation (D5:D7 all = 0) ⇒ use reduction: D1 × C8. If any ventilation value is given ⇒ use the lowest positive among D5:D7. Formula (modern Excel / 365) – enter in D10...

You are most welcome. Keep exploring Excel with ExcelDemy!

Hello, You can achieve this by using a formula that inserts a line break between "Top" and "Bottom." In cell D1, enter: After that, make sure Wrap Text is enabled for cell D1 (Home tab → Alignment group → Wrap Text). This way, the space in A1 will be replaced with a line break, and you’ll see...

Hello, Thanks for the quick follow-up. Here’s exactly how to wire the file so the macros work. Make a backup: Save a copy first. Save as macro workbook File → Save As → choose Excel Macro-Enabled Workbook (*.xlsm). Paste the VBA (Standard Module) Press Alt+F11 → Insert → Module. Paste the...

Hello Muh, You will need to use VBA code to perform the tasks you mentioned. Paste this VBA (Standard Module): Press Alt+F11 >> select Insert >> select Module. Paste the code below. Option Explicit '=== CONFIG (tailored to your file) === Const SH_ERP As String = "ERP DATA" Const SH_ENTRY As...

Hello Jerubin, The formula is showing only 5 names data because you didn't update the cell reference to include the rest of the names. Updated Formula...

Hello Gic David, You can achieve this in Excel using the Power Query tool, which is perfect for combining rows based on matching addresses and merging names into a single line. Here’s a step-by-step guide: 1. Load your data into Power Query Select your data range. Go to the Data tab >> choose...

Hello Devroy, To do FIFO allocation of minus values against plus values for each customer, you can use a helper column with a formula to track cumulative amounts. Sort your data by Customer and Date. Use a formula like this in your helper column (assuming amounts in F2): =IF(F2>0, MAX(0...