Naveenaggarwal
New Member
- Joined
- Jul 17, 2018
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Hi!,
In my Data Sheet, I am having below data.
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
In other summary sheet, i have taken out the top 5 defects as below :
<colgroup><col style="mso-width-source:userset;mso-width-alt:3397;width:73pt" width="97"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
What i want is to create a list of main contributor from datasheet with respect to above top defects table. something like below :
<colgroup><col style="mso-width-source:userset;mso-width-alt:1582;width:34pt" width="45"> <col style="mso-width-source:userset;mso-width-alt:2443;width:53pt" width="70"> <col style="mso-width-source:userset;mso-width-alt:2048;width:44pt" width="59"> </colgroup><tbody>
</tbody>Please suggest the formula
Thanks
Naveen Aggarwal
In my Data Sheet, I am having below data.
Rejection Details | Jul-2018 | 22 | 34 | 31 | 22 | 24 | 22 | 36 | 36 | 23 | ||
Date | Model | Part | Production Qty. | M.Cap Miss | M.Dent Mark | M.Fin | M.Flow Mark | M.Scratch | M.Shrinkage | M.Silver Marks | M.Warpage | M.Weld Line |
17-07-18 | A | Molding L | 500 | 0 | 5 | 0 | 8 | 0 | 9 | 13 | 11 | 2 |
18-07-18 | B | Upper (PMMA) | 600 | 5 | 26 | 19 | 0 | 3 | 6 | 12 | 8 | 0 |
17-07-18 | A | Rr Lic Grn Camera | 700 | 17 | 3 | 12 | 14 | 21 | 7 | 11 | 17 | 21 |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
In other summary sheet, i have taken out the top 5 defects as below :
Top Defects | |
Defects | Qty |
M.Silver Marks | 36 |
M.Warpage | 36 |
M.Dent Mark | 34 |
M.Fin | 31 |
M.Scratch | 24 |
M.Weld Line | 23 |
M.Cap Miss | 22 |
M.Flow Mark | 22 |
M.Shrinkage | 22 |
#N/A |
<colgroup><col style="mso-width-source:userset;mso-width-alt:3397;width:73pt" width="97"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
What i want is to create a list of main contributor from datasheet with respect to above top defects table. something like below :
M.Silver Marks (Top Defect) | ||
Model | Part Name | Quantity |
| | |
| ||
| |
<colgroup><col style="mso-width-source:userset;mso-width-alt:1582;width:34pt" width="45"> <col style="mso-width-source:userset;mso-width-alt:2443;width:53pt" width="70"> <col style="mso-width-source:userset;mso-width-alt:2048;width:44pt" width="59"> </colgroup><tbody>
</tbody>
Thanks
Naveen Aggarwal