Search results

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

Hello Andrewalwin, Yes, Excel can be used for enterprise property management, but it has clear limits. Excel works well for analysis, reporting, budgeting, and forecasting, especially when combined with structured tables, Power Query, and Power Pivot. For small to mid-sized portfolios, many...

Hello Tony Mac, Use an exact match lookup on the comma-separated tokens (no wildcards), e.g., with TEXTSPLIT + XLOOKUP: =TEXTJOIN(", ",TRUE,IFERROR(XLOOKUP(TRIM(TEXTSPLIT(A1,",")),$D$1:$D$100,$E$1:$E$100),"")) This splits A1 by commas, trims spaces, then does an exact lookup for each code (so...

Hello Pradneshwaje, You can prepare a petty cash report directly from the attached bank statement by summarizing only the small, frequent expenses and matching them with the funding entries. Identify petty cash funding Look for credits like “petty ca”, “M S NEW T / ICIC / petty ca”...

You are most welcome. Glad to hear that this solution helped you. Keep exploring Excel with ExcelDemy!

Hello Isabellar, It looks like some of the values in your range are stored as text, even though they appear as numbers. When that happens, Excel ignores those cells in the SUM calculation. Formatting the cells as “Number” does not convert the underlying value. The easiest way to fix this is to...

You are most welcome. Hopefully your problem is solved now.

Hello, It sounds like the data is being pasted below the table because the code is not detecting the table’s data range and is instead using the next empty row on the worksheet. To fix this, make sure your VBA is adding rows inside the Excel Table, not outside it. You can replace your paste...

You are most welcome. Thanks for your feedback and appreciation. Keep helping each other to make the community stronger.

Hello, You’ve done the hard part already (writing to the sheet chosen in E6: Type). To also log the same entry to Total, write the values once into an array and append that row to both sheets. The macro below is a drop-in replacement that avoids Select/Activate (more reliable) and validates the...

Hello Kata Davis, It sounds like Excel’s gridline color might have been changed globally, which sometimes happens after theme or display updates. Let’s go through a few checks to restore the default gridlines permanently: Check Gridline Visibility from the View Tab: Go to the View tab on the...

Hello AllanR, You’re very welcome! I’m glad to hear everything is working fine again. It does sound like something in the file may have become corrupted, and restoring from a backup was a smart move. If it happens again, try saving the workbook as a new file (Save As) — this can sometimes...

Hello Allan, If your Name Manager or named function stopped working, try the following steps: Check for broken references: Go to Formulas ➜ Name Manager and see if any of your defined names show #REF!. If so, edit the reference range and correct it. Ensure workbook calculation is enabled...