shamimarita's latest activity
-
shamimarita replied to the thread Calculation based on lookup values.Hello wiferetire, Thanks for your kind feedback! Yes, the formula will automatically prevent the Outstanding Qty from becoming negative... -
shamimarita replied to the thread Calculation based on lookup values.Hello Richard03, Yes, exactly. The formula assumes that the received quantity is allocated to duplicate PO# rows from top to bottom...
-
shamimarita replied to the thread 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...
-
shamimarita replied to the thread Calculation based on lookup values.Hi snowbunny99, You can handle the duplicate PO# rows by allocating the received quantity to each ordered row sequentially instead of...
-
shamimarita replied to the thread 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...
-
shamimarita replied to the thread 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...
-
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...