Solution:
Redcoal - Looks like a great solution, it returned all the correct answers for each of the 3 part numbers in the data set. I'll go test it out further in the large data set I have. Thank you so much for the prompt response....considering I spent a good 2 hours trying to work this out myself w/o any success.

Marvin P, unfortunately your solution did not return the correct results but I appreciate your response.