Thanks Fotis

I haven't worked with many Array formulas so I will have to play around with this to see exactly what it is doing. It worked perfectly on the first BOM, but I'll need to tweek it to take care of the others it seems.

I am going to call it solved! Thanks again.