Search results

Hello BecJ, You can easily achieve exactly what you want with Conditional Formatting using separate rules (instead of the 3-Color Scale, which creates gradients/shades). Step-by-step solution: Select the range of cells containing your % compliance values (e.g. the whole column or specific cells...

Hello Jasperstone62, Thanks for your contribution. If you're referring to building or improving an inventory system in Google Sheets, the approach usually depends on how dynamic and automated you want it to be. A basic setup can work well with formulas (like SUMIF, FILTER, or QUERY) to track...

Hello Lee, It sounds like the issue is coming from how XLOOKUP behaves with filtered data. By default, XLOOKUP does not ignore filtered (hidden) rows, so it may return a value that isn’t currently visible, or miss what you expect as the “last visible” result. If your goal is to return the last...

Hello Christina, The courses typically offer certificates upon completion. These certificates usually serve as proof of your skills and may help in job applications or professional development. You can check the course details on the official website for any additional instructions on how to...

Hello doodleali, Good point! Text-formatted numbers or hidden spaces are often the reason SUM doesn’t include certain cells. Using ISNUMBER is a great way to check, and converting with Text to Columns or multiplying by 1 usually fixes it quickly. Also, another quick option is using VALUE() or...

You are most welcome. Let us know your feedback!

Hello Jasongonzalez, After converting your data range to an Excel Table, existing charts don't auto-update with new rows because their series still use old static ranges (e.g., 'log'!$A$3:$A$200) instead of dynamic table references. Quick fix (no need to recreate charts): Click the chart →...

Hello Andrewalwin, Tracking multiple loans (different rates, schedules, maturity dates) for repayments, balances, and due dates is straightforward with the right setup. No VBA needed, use PMT, IPMT, PPMT, CUMIPMT, etc., for calculations. Check out our free Multiple Loan Amortization Schedule...

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