Search results

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

Hello Gina, You're welcome! No worries, setting up the structure can be a bit tricky at first. Here’s a simple example to help you visualize how your data and leaderboard can be set up: 1. Data Source Sheet Structure (e.g., “Data” sheet): Name Month Score Alex Jan 50 Maria Jan 60 Alex...

Hello Gina, You can set up a dynamic leaderboard that pulls data from another spreadsheet and updates based on the selected month. Here’s a step-by-step approach: 1. Use the INDIRECT or IMPORTRANGE Function (depending on your Excel version): If your data is in another workbook, you can use...

Hello Isaggs, It sounds like you’ve created tabs (worksheets) using VBA/macros, but some of them stop working or become unresponsive. This is a common issue and can be caused by a few things: Possible Reasons & Solutions: Event Macros Disabled: If your tabs rely on worksheet event macros (like...

Thanks for the detailed update! The Error 2042 from the Application.Match usually means the value wasn't found. A few quick checks: Ensure v is a string: v = CStr(v) Use Debug.Print "|" & v & "|" and compare with each header to spot hidden spaces or characters. Range(sTempRange).Offset(-2, 3)...

You are most welcome. Glad to hear that the solution worked. Keep exploring Excel with ExcelDemy and help each other to make the community stronger.

Hello, I see what you’re trying to do, and you’re close, but there’s a misunderstanding in how Enums work in VBA and how to reference them dynamically. What’s happening: v = Application.VLookup(...) returns the name of the BudgetItem as a string (like "Entertainment"), not the Enum value...

Hello Malt, This error typically appears when you're using features like PivotTables, Charts, or Data Validation that rely on a specific reference range, and that reference is broken, missing, or incorrectly defined. Here are a few things you can check: Named Ranges: Make sure any named range...

Hello Julie, Try this updated code and let me know: Sub FormatWeeklyBadgeReport() Dim ws As Worksheet Dim lastRow As Long Dim i As Long Dim nameToFind As String Dim cell As Range Dim dict As Object Set dict = CreateObject("Scripting.Dictionary") Set ws =...

Hello Julie, The problem most likely arises from ws not being properly set, especially when running the macro from the Personal Macro Workbook, which doesn’t automatically refer to the intended worksheet in the active workbook. ws.Range("C4:M" & lastRow).Sort Key1:=ws.Range("C4")...

Hello Ehunt256, You're doing an amazing job pushing through each challenge, and your persistence is really paying off! Let’s walk through your three key requests and update your macro accordingly so you can finish strong Private Sub CommandButton1_Click() Dim sn As String Dim wsLog As...

Hello Tsd5562, You can use the following VBA code to automatically insert a new column labeled "Gross Profit" to the right of "Revenue (USD)" and calculate the values as Revenue – COGS for each row: Sub AddGrossProfitColumn() Dim ws As Worksheet Dim lastRow As Long Dim i As Long...

Hello Badriah, Great job on creating your first User Defined Function (UDF)! Let me address your questions one by one: 1. Why use Function instead of Sub for custom formulas? In VBA, Function procedures return a value, which is necessary for creating custom Excel formulas. On the other hand...