Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Service Fill Rate
Dear Expert
I am a new to excel and i need to calculate the fill rate using the below data. My data is large , est around 2000 SKU lines I try search from the post here, but no luck. Appreciate your expertise. Data Sample Plate No. Date Ord.Ord No. SKU. Supp. ABC123,12/1/08,123,Code1,Yes ABC123,12/01/08,123,Code2,No ABC124,13/01/08,125,Code3,Yes ABC124,13/01/08,125,Code4,Yes ABC125,13/01/08,126,Code5,Yes I wish to get the answer how Plate No. with full parts supplied (yes) in this case Ans: is 2 (ABC124 and ABC125) In addtion i may need to select by date range. Thank You Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Average Length of Service | Excel Worksheet Functions | |||
Calculating a daily rate when the rate could be fixed or variable | New Users to Excel | |||
calculating a formula for a service level | Excel Worksheet Functions | |||
calculating a formula for a service level | Excel Worksheet Functions | |||
calculating service dates | Excel Worksheet Functions |