Latest activity
-
EEmilXmulo replied to the thread Calculation based on lookup values.One thing I’d be interested to know is whether the received quantity table can contain multiple receipt entries for the same PO# as...
-
shamimarita replied to the thread [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... -
MMaps replied to the thread [Solved] Tax Calculation.Good day. I note that if an employee is engaged on the second month of the tax year, the rebate is calculated as though the employee...
-
Rrobertgerber updated their status.In Geometry Dash Spam, players control a character and try to move through levels without hitting obstacles. Players need to click at...
-
Rritarodriguez updated their status.One of the most interesting parts of FNAF Games is its story. At first, the games may seem like straightforward horror games, but they...
-
Bbenx01 replied to the thread Advance Filter using Macro or VBA.But also this is a helpful discussion for anyone working with Excel VBA and advanced filtering. I like how practical these forum threads...
-
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...
-
Wwiferetire replied to the thread Calculation based on lookup values.I really like the way you explain, easy to understand, shamimarita. If the total received quantity is greater than the total ordered...
-
Wwiferetire reacted to shamimarita's post in the thread Calculation based on lookup values with
Like.
Hi snowbunny99, You can handle the duplicate PO# rows by allocating the received quantity to each ordered row sequentially instead of... -
Wwiferetire reacted to shamimarita's post in the thread VLOOKUP values separated by commas with Like.
Hello, If D1:D100 (or the lookup range) is very large, the formula will still work correctly, but performance can slow down because...
