shamimarita's latest activity
-
shamimarita replied to the thread Number of text cells by color.Hello PomDave, Let us know your feedback and solution. -
shamimarita replied to the thread How can I return the latest value based on a matching ID?.Hello Marktuan, In Excel 365, a simple and efficient way is to combine XLOOKUP with MAXIFS. Assuming your data is in A2 (ID, Date...
-
shamimarita replied to the thread Moving duplicate date data to another column.Hello AprilLynnRN, Thank you so much for the kind words. Glad to hear it worked! The spill error is expected here. Excel Tables do not...
-
shamimarita replied to the thread Moving duplicate date data to another column.Hello AprilLynnRN, Since you're using Excel 365, I think you're actually very close to a formula-only solution and may not need Power...
-
shamimarita replied to the thread Number of text cells by color.Hello PomDave, Yes, this is possible with a small VBA user-defined function. Excel formulas cannot directly count cells by font color...
-
shamimarita replied to the thread [Solved] Tax Calculation.Hello Maps, Glad to hear that the issue is resolved now. You are most welcome.
-
shamimarita replied to the thread [Solved] Tax Calculation.Hello Maps, Try this formula there: =MIN(D17*5%,215*((YEAR($C$23)-YEAR($C$31))*12+MONTH($C$23)-MONTH($C$31)+1)) For your spreadsheet...
-
shamimarita replied to the thread [Solved] Nested If function not working.Hello TrevorWestbrook, Thanks for your feedback. Keep contributing on the ExcelDemy forum to help each other.
-
shamimarita replied to the thread [Solved] Tax Calculation.Hello Maps, It is possible to show both: the rebate applicable for the current month (Column C), and the year-to-date rebate value...
-
shamimarita replied to the thread [Solved] Tax Calculation.Good day. You can place the rebate formula in a separate cell and then reference that cell inside the PAYE formula. For example, if...
-
shamimarita replied to the thread [Solved] Tax Calculation.Hello Maps, Yes, this can be done. Since your tax year runs from July to June, use the tax period start and end dates in your sheet...
-
shamimarita replied to the thread [Solved] Tax Calculation.Hello Maps, Yes, it is possible. You can use one dynamic formula that checks the employee’s salary bracket and age automatically. For...
-
shamimarita replied to the thread [Solved] Help on creating an excel spreadsheet with formulas on Pro Forma Statements.Hello Zebrabeside, You can follow the same Excel structure shown in the previous reply. The External Financing Needed (EFN) can be...
-
shamimarita replied to the thread Time additions dd:hh:mm.Hello Lee, Thanks for sharing the sample. In your sheet, the values in column E are being treated as normal time values (hh:mm:ss), so...
-
shamimarita replied to the thread [Solved] Tax Calculation.Hello Maps, Yes, using your spreadsheet as the practical example, the portal value of 652.99 can be matched. In your sheet: Gross...