mark available items

[beman]

Hi,

I searched the forum but couldn't find any issue similar to mine.
I hope someone can help me out.

I'm working with a pivot and I need to flag if all missing part belonging to an item are available and that the item can be produced.

It would be great if I can get the below as shown in the Produce column automated.

Part	Missing Comp.	Needed	Stock	Status	Produce
123ABC	88-3318-01	5	0	Missing	No
	88-3333-04	5	5	AV	No
	88-1793-01	5	0	Missing	No
456DEF	88-0034-01	1	20	Av	Yes
	88-5434-01	1	35	Av	Yes
	88-0495-01	1	157	Av	Yes

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

VBA code is also welcome

Thanks in advance for your help.

 

[Logit]

Assuming this presentation:

Part	Missing Comp.	Needed	Stock	Status	Produce
123ABC	88-3318-01	5	0	Missing	NO
	88-3333-04	5	5	AV	YES
	88-1793-01	5	0	Missing	NO
456DEF	88-0034-01	1	20	Av	YES
	88-5434-01	1	35	Av	YES
	88-0495-01	1	157	Av	YES

<tbody>
</tbody>

In F2, paste then drag down the column.

=IF(D2>=C2,"YES","NO")

 

[beman]

Hi Logit,

Thanks for the reply.

What I want it to do is, that it will only state Yes on the column Produce when all components are available for that specific part.

So for part 123ABC, all should be NO in the Produce column, because all 3 components are required to produce part 123ABC.
And ones all components are available like for part 456DEF all should show YES, this will then be easy to spot if a part can be produced.

Assuming this presentation:

Part	Missing Comp.	Needed	Stock	Status	Produce
123ABC	88-3318-01	5	0	Missing	NO
	88-3333-04	5	5	AV	YES
	88-1793-01	5	0	Missing	NO
456DEF	88-0034-01	1	20	Av	YES
	88-5434-01	1	35	Av	YES
	88-0495-01	1	157	Av	YES

<tbody>
</tbody>

In F2, paste then drag down the column.

=IF(D2>=C2,"YES","NO")

 

[Logit]

=IF(D2>=C2,"YES","")

Part	Missing Comp.	Needed	Stock	Status	Produce
123ABC	88-3318-01	5	0	Missing
	88-3333-04	5	5	AV	YES
	88-1793-01	5	0	Missing
456DEF	88-0034-01	1	20	Av	YES
	88-5434-01	1	35	Av	YES
	88-0495-01	1	157	Av	YES

<tbody>
</tbody>