I have a workbook that split qty based on criteria.
That is if value of column AQ statistics value is either kg,u,m2,2u as criteria for formula in column Y ,qty1 header either to extract the qty in column w .
but if the criteria is L in column AQ THEN take value of column N multiply value of column O, otherwise take the value of column W if the VALUE shown in column AQ are u,m2,2u . if kg is shown in column AQ , then do nothing.
So far trying formula as below but need some adjustments
Please Login or Register to view this content.
Bookmarks