Forum Discussion
What formula to use
Good evening, Would anyone be able to help me with the following please? I have a formula that looks at a table for specific parts and returns "kitting". The problem is that the order may have kit...
This request is not clear. Even if (as I suspect) we do not need to know what "G KITTING" is:
- Does each row represent the intended delivery of one PART?
- In cell F1, what does "COUNT LINES COLUMN" mean?
- How can a formula identify what constitutes an ORDER? E.g., does an ORDER comprise all rows with the same Delivery Number?
- What is the formula intended to return if the ORDER contains only G KITTING: "only kitting" (as per the post) or "GKITTING OUTSIDE" (as per cell F1)?
- What is the formula intended to return if the ORDER contains no G KITTING?
- Might this worksheet be expected to handle types of kitting other than G KITTING, if such exist?
Which version of Excel are you using?