Search results

Hello Lee, What you're describing is selecting from a drop-down in B2 to automatically move the title to B7 + pull its related info (below it) to the top, with easy undo, and no VBA (due to protection), which isn't directly possible with formulas alone. True "moving" or rearranging rows on...

You are most welcome. Keep exploring Excel with ExcelDemy. Help each other make the forum more useful.

Hello Lee, Thanks for sharing the sample sheet. I can see that your TASK NAME list is in column D, and you want to select a task from a drop-down and show that selected item at the top of the sheet. You can do this with a Data Validation drop-down + XLOOKUP. Step 1: Create the Drop-Down...

Hello Enigme, Yes, you can create the chart without manually entering the totals. A good approach is to calculate the totals for each region using a SUMIF formula and then create the chart from that summarized data. Assuming: Column A contains the Region names Column F contains the Green...

Hello JORGE W. ROSERO, Thanks for sharing your suggestion. Using a nested IF formula can definitely help handle multiple conditions in this case. Just be careful with the structure and parentheses, since a small mistake there can cause the formula not to work properly. In many cases, the issue...

Hello JORGE W. ROSERO, Thank you for sharing this idea. Using unique product codes for each item and size combination is definitely a practical approach for inventory management. It helps avoid confusion and makes it much easier to track stock movements, especially when using tools like...

Hello JORGE W. ROSERO, Thanks for sharing the alternative formula. Yes, using: =DATEDIF(StartDate,EndDate,"D")+1 This formula is another good way to calculate the total number of days between two dates, including the start date. Just keep in mind that DATEDIF is mainly useful for getting the...

Hello Lee, If your drop-down list is created using Data Validation, the easiest way is simply to reference the cell that contains the drop-down. Example: 1. Suppose your drop-down list is in cell B2. 2. Go to the cell at the top of the page where you want the selected project title to appear...

Hello Cashby, Your nested IF is working syntactically; it’s the logic/order that’s wrong. Right now, you test the lowest tier first (M15 = 12,522). Since E15 (66,422 in your sheet) is already greater than 12,522, Excel returns N15 immediately (4%) and never reaches the higher tiers (5%, 6%)...

Hello Heato, Welcome to the forum! Your uniform tracking setup is a very common need (schools, security companies, factories, etc.), and Excel can handle it quite nicely with dependent dropdowns, simple formulas, and conditional formatting for low stock alerts. Here’s a practical approach to...

You are most welcome. Keep contributing in ExcelDemy forum.

Hello MeesaWorldWide, I found the exact cause of the mismatch in the Credit Card 2 sheet (and the same small issue exists in Credit Card 1). The Problem: Look at the Credit Card 2 sheet, row 8 (Month 1): Interest = 72 (correct: 3600 × 0.02) Principal = 28 (correct: 100 − 72) Balance = 3500 ←...

Hello Andrew Skamel, You can calculate the number of days between two dates (stored in separate cells) very easily in Excel. Assume: Start Date is in A1 End Date is in B1 To count the number of days between them (including the start date), use: =B1 - A1 + 1 If you do not want to include the...

Hello Kkathol, It’s returning “No matching titles” mainly because the criteria are being applied in a very fragile way (repeating FILTER + INDEX many times), and there’s at least one cell mismatch in your Stipulation B: In your description, Location = F5, but your formula checks location...

Hello MeesaWorldWide, This is a super common “why doesn’t NPER match my table?” situation, and it’s almost always one of these two things: 1. Payment timing mismatch (most common) NPER() assumes payments happen at the end of each period by default (type = 0). But many amortization tables...

Hello Kdakwa, Thank you for explaining the issues so clearly. Moving the monthly tables can definitely cause some of the formulas and formatting from the video to stop working. Here are solutions to each point. 1. Tracking vacation and sick accrual Since you accrue 3.34 hours per pay period...

Hello Dburd, Thank you for sharing your file. The structure you’ve created is a solid starting point for an inventory system. To make it more automated and efficient in Google Sheets, I would suggest a few improvements. 1. Separate Product List and Transactions Instead of updating stock...

Hello Lucasj, Thanks for the clear explanations. Your examples for Range("A1:B10").ClearContents to remove values but keep formatting is exactly what beginners need to see, simple and practical. To add a bit more context for others reading: .ClearContents only removes the data inside the...

Hi Lucasj, Yes, this can be done with VBA using the Advanced Filter. You don’t need to loop through the data row by row. The idea is to create a small criteria range (can be on another sheet or a hidden area) and then apply Range.AdvancedFilter in VBA. In VBA, you would: Define the source...

Hello, If D1:D100 (or the lookup range) is very large, the formula will still work correctly, but performance can slow down because XLOOKUP is executed once for each split value. To handle large ranges more efficiently, you can consider these tips: Limit the lookup range to only the rows that...