Latest activity
-
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...
-
RRichard03 replied to the thread Calculation based on lookup values.This makes sense to me, and I like the sequential allocation approach. I just want to clarify one point: does this formula assume that...
-
uu888eucom updated their status.UU88 là thương hiệu cung cấp dịch vụ giải trí trực tuyến chuyên nghiệp, trực tiếp phát triển và vận hành hệ sinh thái game đa dạng trên...
