Search results

  1. shamimarita

    Calculating response times from timestamp logs that cross midnight

    Hello Appel Malade, Thank you for sharing this detailed and helpful explanation. You're absolutely right. The MOD function is a simple and effective way to calculate elapsed time when a call starts before midnight and ends after midnight. For example, if the start time is in A2 and the end...
  2. shamimarita

    ActiveCell and copy

    Hello Jill, You can use ActiveCell as the destination when copying a range with VBA. Since you want to copy data from B7 to the cell selected by the user, try this: Option 1: Copy data with formatting Range("B7:B39").Copy Destination:=ActiveCell For example, if the user selects B200 before...
  3. shamimarita

    Excel not calculating columns correctly with a formula

    Hello Bar, Welcome to the ExcelDemy Forum! Thank you for explaining your issue and sharing your spreadsheet. I reviewed the formulas you provided and noticed a few things that may explain the inconsistent weekly totals. 1. Correct the formula in column G (Total Hours) Your current formula...
  4. shamimarita

    xlookup lookup_area

    Hello garfieldandew and williamcorlin, Thanks both for your suggestions. The TOCOL approach is useful for converting the lookup area into a single column, but as williamcorlin pointed out, the main challenge is keeping the cost in column N associated with the correct original row. That is why...
  5. shamimarita

    Barcode Check out from an inventory

    Hello Ehunt256, Yes, you found the correct solution! The Run-time error 13: Type mismatch can occur because one or more cells in the Inventory range may contain a value that Trim() cannot handle directly, such as a number or another non-text value. Your revised line: If...
  6. shamimarita

    [Solved] Tax Calculation

    You are welcome, Maps. It's my pleasure to help you.
  7. shamimarita

    [Answered] Can Microsoft Certification Exams Help Build a Stronger IT Career Path?

    Hello annajohn09, Yes, Microsoft certifications can be useful as part of a long-term IT learning plan, especially when the certification matches your intended career path. For example, if you are interested in cloud computing, Azure certifications can provide a structured learning path...
  8. shamimarita

    xlookup lookup_area

    Hello JJK, Good morning, and thanks for the update. If the same BYROW approach works in another workbook but not with the SAP export, the issue is likely related to how the SAP data is stored rather than the BYROW function itself. SAP exports often contain values stored as text, extra spaces...
  9. shamimarita

    [Solved] Tax Calculation

    Hello Maps, Since you are using Office 365, we can use the complete LET formula rather than changing individual parts of the previous formula. Based on the cell references from our earlier discussion, use this formula for your YTD tax: =IF(C23<MAX(C31,C24),0, LET(...
  10. shamimarita

    xlookup lookup_area

    Hello JJK, You can use XLOOKUP with BYROW to search for an Item ID across multiple columns (E to M) and return the corresponding cost from column N. Assuming your lookup value is in cell P2, try this formula: =XLOOKUP(TRUE,BYROW(E2:M1000,LAMBDA(r,OR(r=P2))),N2:N1000,"Not found") BYROW checks...
  11. shamimarita

    [Solved] Tax Calculation

    Hello Maps, I checked this again, taking into account that you are using an older version of Excel. The YTD rebate of 673.97 is correct. Since the employee started on 01/09/2026, the rebate should only be calculated from her engagement date: 8200 / 365 × 30 = 673.97 The reason the YTD tax is...
  12. shamimarita

    [Solved] Tax Calculation

    Hello Maps, You are most welcome. Thanks for your feedback and appreciation, it really means a lot to me.
  13. shamimarita

    Number of text cells by color

    Hello Dave, First of all, I hope your wife is doing much better now. Please don’t worry about the delayed reply. Thanks for attaching a sample of your spreadsheet. Since you mentioned that you haven’t used programming for a long time, we can keep the solution as simple as possible. From your...
  14. shamimarita

    How to distribute Qty equally Among Months in case of change in dates.

    Hello Pankaj Kumar, You can achieve this with formulas so that both the month headers and the distributed quantities update automatically whenever the dates change. 1. Generate the Month Headers In cell F5, enter the following formula...
  15. shamimarita

    [Solved] Tax Calculation

    Hello Maps, I’m glad the formula is working correctly in Office 365. Since the LET function is not available in older versions of Excel, you can use the same calculation by replacing the variable names with their actual cell references...
  16. shamimarita

    [Solved] Week/Supervisor wise attendance

    Hello EmilXmulo, Thank you for your feedback! We’re glad you found the dynamic week setup and the SUMPRODUCT formula useful for handling supervisor-wise attendance reports. If you need any further modifications or want to make the report more dynamic, feel free to let us know.
  17. shamimarita

    [Solved] Tax Calculation

    Hello Maps, The previous formula calculates the year-to-date rebate from the start of the tax year, so if an employee starts in the second month, it would incorrectly include the first month's rebate as well. The calculation should instead start from the later of: the tax-year start date, or...
  18. shamimarita

    nested if statement

    Hello Wandy, You can combine Annual Check and Monthly Check using the OR function, since both use the same conditions for the date in D2. =IF(D2="","",IF(OR(C2="annual check",C2="monthly check"),IF(D2<TODAY(),"Expired",IF(D2<=TODAY()+7,"Expiring Soon","OK")),"")) This formula will return...
  19. shamimarita

    Comparing percentage values against constants, less than, greater than, and ranges

    Hello bevtyler, Yes, you can simplify this quite a bit instead of continuing with multiple nested IF statements. If the criteria are in A2 and the percentages to test are in E2, you can use the following formula in I2 and copy it across: =LET( x,E2*100, c,A2, t,TRIM(SUBSTITUTE(c&"","%",""))...
  20. shamimarita

    Add PassCode requirement for one particular Macro in a Spreadsheet

    Hello Almadolam, You can place the column-unhiding commands directly inside the password-protected macro. Try the following code: Sub INTEGITUS_HQ_FORMAT_VIEW() Dim userInput As String Const correctPassword As String = "345" userInput = InputBox( _ "Enter the security...

Online statistics

Members online
0
Guests online
234
Total visitors
234

Forum statistics

Threads
468
Messages
2,092
Members
7,094
Latest member
hi888itcom
Back
Top