Hi, I've been trying to achieve something since yesterday but I haven't had any luck yet. Here's what's going on.
<tbody>
</tbody>
I have those descriptions, with a quantity to their left, as you can see there's DDBXD, DBLXD, DWHXD at the very end of the sentence. What I basically want is a formula that will let me know how many components I need (In this case, how many "IS", "PER7", "RPA") based on their color.
For example, as a result I would like something like this.
<tbody>
</tbody>
Would appreciate any help on this, thanks!
6 | RSXF2 LED P3 40K AWFD MVOLT IS PER7 DDBXD |
8 | RSXF1 LED P4 40K WFL MVOLT IS FAO DBLXD |
5 | RSX1 LED P1 50K R3 MVOLT IS DWHXD |
1 | RSXF1 LED P4 40K AWFD MVOLT RPA DDBXD |
5 | RSXF1 LED P3 40K AWFD MVOLT IS DDBXD |
<tbody>
</tbody>
I have those descriptions, with a quantity to their left, as you can see there's DDBXD, DBLXD, DWHXD at the very end of the sentence. What I basically want is a formula that will let me know how many components I need (In this case, how many "IS", "PER7", "RPA") based on their color.
For example, as a result I would like something like this.
Comp | Color | Qty needed |
IS | DDBXD | 11 |
IS | DBLXD | 8 |
IS | DWHXD | 5 |
RPA | DDBXD | 1 |
PER7 | DDBXD | 6 |
<tbody>
</tbody>
Would appreciate any help on this, thanks!