Latest activity
-
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... -
Ssiriusjewelers updated their status.Explore beautiful mangalsutra designs for women in modern and traditional styles. Find elegant gold and diamond designs for daily wear...
-
Aalexiaamber replied to the thread Number of text cells by color.Hi Dave, Yes, this can be done with VBA, but the important point is that Excel’s normal COUNTIF/COUNTIFS functions don’t directly count...
-
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...
