Array-enter (press ctrl+shift+Enter instead of just Enter) the following formulas:

=MAX(IF(A1:A100=C1,B1:B100))

=MIN(IF(A1:A100=C1,B1:B100))

where C1 contains the part "number" entered as the same type as the values in column A (text or numeric).

Thanks for the quick response.

I gave it a go, it looks in concept like what I need but it has the issue of returning the greatest value in B1:B100 regardless if that particular value is associated with the value in C1. It seems to be just checking if A1:A100 has the C1 value but not using it again for the filtering.