| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One part number with several substitute numbers
Hi, I have the below data sample:
A B C D PRT STK SUB_SUB_PART SUBSTK 0068605568 0 4970450487 0 0068605726 0 4970450826 16 0068605734 0 0068611051 0 0068612133 1 0068612722 17 0068612133 1 0068611051 0 0068612409 0 0068603220 0 0068612409 0 0068605046 0 0068612721 4 0068612132 3 In this case, there is a part number (column A), quantity of this part (B), substitute part number (C), and quantity of the substitute. For instance, part 0068605568, has qty=0 and a subst. 4970450487 also with qty=o. Part 0068612133 with qty=1 and a subst. 0068612722 with qty=17, and another subst. 0068611051 with qty=0. My question is, how do i know how many parts i have between the part number and it's substitutes. In the latter case i would have a total of 1+17 parts. Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Substitute to Retun a number | Excel Discussion (Misc queries) | |||
| =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE.... max. limit 8 :( | Excel Discussion (Misc queries) | |||
| How do I substitute text for numbers | Excel Discussion (Misc queries) | |||
| replace or substitute a letter for a specific number | Excel Discussion (Misc queries) | |||
| Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
Threaded Mode
