LinkBack URL
About LinkBacks
Hi everyone,
Understand my problem can be complex. Allow me to explain in detail.
If you refer to my excel file, there were a number of different types of (MI) Measuring Instrument types (TPG, PG, CMM SRT etc)
Previously, I wanted to achieve items with PG,TPG,TRG,RG or GB MI type will repeat themselves under the lower section: MEASURING INSTRUMENT USED at cell B110
In addition, items with other types of MI will only repeat once e.g CMM, SRT, TM etc
My current excel formula has achieved the following:
1) Items will either TPG, PG, TRG, RG, GB will appear depending on the number of times it appears in the upper section
2) Items with other types of MI will only repeat once
3) Items with VI and NOTE type of MI will not appear at all
However, I realized I needed to modify my existing formula by ensuring the following:
a) item with "ID" indicated under the L/N will not appear, regardless of MI type. This condition is similar to No. 3 (Please refer to the cell in yellow in the attached workbook), although its MI type is PG. Based on the current formula, it will appear under section "MEASURING INSTRUMENT USED"
b) Similar items which appear more than once will only appear once, regardless of MI type. This condition is similar to No. 2 (Please refer to cell in blue in the attached workbook), although its MI type is TPG. Based on the current formula, it will appear 4 times under section "MEASURING INSTRUMENT USED", similarly to the number of times I have added in the upper section.
Can I kindly request any assistance to modify my existing formulas in the attached workbook?
Much appreciated.
Jude
Register To Reply
Bookmarks