aka_krakur
Active Member
- Joined
- Jan 31, 2006
- Messages
- 438
I need to somehow fix this formula to work. It's not working so far.
Here is a sample data set first:
Here is a sample data set first:
Book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | MONTH_SORT | INCIDENT_KEY | PRODUCT_FAMILY | REPORTED_DEV_CLARIFICATION | ||
2 | 7/1/2006 | 77628-1-1 | Product1 | X100-N/A; | ||
3 | 7/1/2006 | 77651-1-1 | Product1 | X100-N/A; | ||
4 | 7/1/2006 | 77653-1-2 | Product1 | X100-N/A; | ||
5 | 7/1/2006 | 77655-1-1 | Product1 | 1158-N/A;1536-Handle; | ||
6 | 7/1/2006 | 77656-1-2 | Product1 | X100-N/A; | ||
7 | 7/1/2006 | 77656-1-3 | Product1 | X100-N/A; | ||
8 | 7/1/2006 | 77661-1-2 | Product2 | 2578-Stent; | ||
9 | 7/1/2006 | 77662-1-1 | Product1 | X100-N/A; | ||
10 | 7/1/2006 | 77676-1-1 | Product1 | X100-N/A; | ||
11 | 7/1/2006 | 77684-1-1 | Product1 | X100-N/A; | ||
12 | 7/1/2006 | 77686-1-1 | Product1 | 1528-N/A;2203-IrregularAppearance;1670-IncorrectRemoval; | ||
13 | 7/1/2006 | 77692-1-1 | Product1 | X100-N/A; | ||
14 | 7/1/2006 | 77692-1-2 | Product2 | X100-N/A; | ||
15 | 7/1/2006 | 77693-1-1 | Product1 | X100-N/A; | ||
16 | 7/1/2006 | 77759-1-1 | Product2 | 1158-FilterBasket; | ||
17 | 8/1/2006 | 77764-1-2 | Product1 | X100-N/A; | ||
18 | 8/1/2006 | 77768-1-1 | Product3 | 2524-Lesion; | ||
19 | 8/1/2006 | 77778-1-1 | Product1 | X100-N/A; | ||
20 | 8/1/2006 | 77781-1-1 | Product1 | X100-N/A; | ||
21 | 8/1/2006 | 77799-1-1 | Product1 | X100-N/A; | ||
22 | 8/1/2006 | 77800-1-1 | Product1 | 2593-Failure; | ||
23 | 8/1/2006 | 77800-1-2 | Product1 | 2593-Failure; | ||
24 | 8/1/2006 | 77800-1-3 | Product1 | 2593-Failure; | ||
25 | 8/1/2006 | 77831-1-1 | Product1 | X100-N/A; | ||
26 | 8/1/2006 | 77831-1-2 | Product2 | X100-N/A; | ||
27 | 8/1/2006 | 77832-1-1 | Product1 | X100-N/A; | ||
28 | 8/1/2006 | 77838-1-1 | Product1 | X100-N/A; | ||
29 | 8/1/2006 | 77842-1-1 | Product1 | 2524-NoPI-NoInformation; | ||
30 | 8/1/2006 | 77848-1-1 | Product1 | X100-N/A; | ||
31 | 8/1/2006 | 77848-1-2 | Product2 | 2578-N/A; | ||
32 | 8/1/2006 | 77852-1-1 | Product1 | 1339-Shaft;2578-DeviceComponent; | ||
33 | 8/1/2006 | 77878-1-2 | Product1 | X100-N/A; | ||
34 | 3/1/2006 | 77880-1-1 | Product2 | 1487-UnabletoFlush;2524-Lesion; | ||
35 | 9/1/2006 | 77914-1-1 | Product2 | 2524-Lesion; | ||
36 | 9/1/2006 | 77914-1-2 | Product1 | X100-N/A; | ||
37 | 9/1/2006 | 77916-1-1 | Product1 | X100-N/A; | ||
38 | 9/1/2006 | 77974-1-1 | Product3 | 2524-Lesion; | ||
39 | 9/1/2006 | 78015-1-2 | Product1 | X100-N/A; | ||
40 | 9/1/2006 | 78020-1-1 | Product3 | 1393-N/A;1528-FilterBasket; | ||
41 | 9/1/2006 | 78036-1-2 | Product2 | 2578-Stent; | ||
42 | 9/1/2006 | 78047-1-3 | Product1 | 1158-N/A;1670-ExcessiveForce;1528-Vessel;1339-Shaft; | ||
43 | 9/1/2006 | 78047-1-4 | Product3 | 1586-Core;2578-N/A; | ||
44 | 9/1/2006 | 78048-1-2 | Product1 | X100-N/A; | ||
45 | 9/1/2006 | 78095-1-2 | Product1 | X100-N/A; | ||
46 | 9/1/2006 | 78105-1-2 | Product1 | 1069-Shaft;1670-UseAfterDamage;1339-Shaft; | ||
47 | 9/1/2006 | 78107-1-1 | Product3 | 1586-Tip; | ||
48 | 9/1/2006 | 78143-1-1 | Product1 | X100-N/A; | ||
49 | 9/1/2006 | 78145-1-1 | Product1 | X100-N/A; | ||
50 | 9/1/2006 | 78162-1-2 | Product1 | X100-N/A; | ||
51 | 9/1/2006 | 78170-1-1 | Product3 | 2578-DeviceComponent; | ||
52 | 9/1/2006 | 78176-1-1 | Product1 | X100-N/A; | ||
53 | 9/1/2006 | 78179-1-1 | Product3 | 2524-Lesion; | ||
54 | 9/1/2006 | 78195-1-1 | Product3 | 1601-Tip; | ||
Sheet1 |