Nicole1023
New Member
- Joined
- Sep 7, 2013
- Messages
- 35
Hi
I have a requirements to find the max value of using the criteria of lines and quantity.
Trying to use formula based but when my macro codes copy a records into a template
there's a changes and the formula was already not arrange intoan specific values and columns.
Is there a possibility to use a macro codes to do my requirements. thanks you.
Here is the actual sample data.
Get the UPH Ave is total quantity/uph per line and get the corresponding model with max quantity per line.
btw, May I know to attached sample data in excel.
Jov
I have a requirements to find the max value of using the criteria of lines and quantity.
Trying to use formula based but when my macro codes copy a records into a template
there's a changes and the formula was already not arrange intoan specific values and columns.
Is there a possibility to use a macro codes to do my requirements. thanks you.
Here is the actual sample data.
Get the UPH Ave is total quantity/uph per line and get the corresponding model with max quantity per line.
Code:
Line1-- DRDRZR2BLK- 14-- 196------
Line1-- - -- 0---------
Line2-- LUCID2 - 14-- 15--------
Line2-- DROIDRZR - -- 86--------
Line3-- DROIDRZR - 14-- 196--------
Line3-- - -- 0-----------
Line4-- DRDRZRHDMAX- 14-- 168---------
Line4-- - 0-----------
and Son On until Line15
--Actual Result/format:
Lines-- Model------- Uph-- qty1-- qty3-- qty4-- Quantity---UPH AVG. ----RESULT
Line1-- DRDRZR2BLK- 14-- 196------ 14-- DRDRZR2BLK
Line1-- - -- 0---------
Line2-- LUCID2 - 14-- 15-------- 7--- DROIDRZR
Line2-- DROIDRZR - -- 86--------
Line3-- DROIDRZR - 14-- 196-------- 14 -- DROIDRZR
Line3-- - -- 0-----------
Line4-- DRDRZRHDMAX- 14-- 168--------- -12--DRDRZRHDMAX
Line4-- - 0-----------
btw, May I know to attached sample data in excel.
Jov
Last edited: