Search results

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

You are most welcome. Glad to hear the the formula solved your problem. Keep helping each other.

Hello Darren, You can rank your table by Score, then Back 6, then Back 3, then Back 1 (all as tiebreakers, in order) using a single formula with SUMPRODUCT. Formula: =1 +SUMPRODUCT(($B$2:$B$8>B3) +($B$2:$B$8=B3)*($C$2:$C$8>C3) +($B$2:$B$8=B3)*($C$2:$C$8=C3)*($D$2:$D$8>D3)...

Hello Becs716, What you’re looking for is a bit beyond standard Excel formulas, but it’s possible! You want to compare two strings cell-by-cell, highlight exactly what’s different (not just whether they’re different), and ignore trivial changes like periods. Here’s a solution using a custom VBA...

You are most welcome. Keep helping each other!

Hello Muh, You can use the following formula to show values based on the Month and Employee. Formula: =LET( combined, VSTACK(Jan:May!$D$5:$P$26), header, Jan!$D$4:$P$4, selected_employee, $D$4, selected_month, UPPER(TEXT(DATEVALUE("1-" & $B$4), "mmmm")), month_col...

Hello Momo, You can use a simple VBA macro to rename sheets with the names of the months automatically. Go to the Developer tab >> select Visual Basic. Click Insert menu >> select Module. Copy-paste the following VBA code. Sub RenameSheetsToMonths() Dim i As Integer Dim monthNames...

Hello Gina, You’re very welcome, and I’m so glad to hear you got everything working and looking great! For your message board idea, you can set one up in Excel! Here are a couple of simple ways to create a message or notice board that lets you customize font and color: 1. Use a Text Box...

Hello Gina, Yes, the formula typically relies on the Month column in your source data (the table with Name, Month, Score), but you do not need to display a Month column in your actual leaderboard. The only place you need the month on the leaderboard sheet is for the dropdown (to select which...