Using MIN function on differing/varying rows.

Hello,

Can't seem to figure this one out even though its probably very simple.

Basically SYSTEM NUMBER (A) contains the PART NUMBERS (B) I want to find the MIN figure of the STOCK (C) for each part contained in the system number. (the outcome to work out if enough parts are available to build a SYSTEM.)

There are not a set number of PARTS in a system, some only have 1, some have 7 or 8.

The worksheet is quite large, this is just a small example. Without going down each SYSTEM line and performing a =MIN and the range of part numbers. is the a formula where excel can perform the =MIN function but when there is a SYSTEM NUMBER Change, so it counts the correct amount of part numbers for that one system?

Thank you in advance

Matt

Edit : added with expected outcome in =MIN column.

Please add expected results manually to show what you want.

Can I confirm that you are using Excel 2019 and not MS365?

Try this copied down:

=IF(OR(A2=A1,A2=""),"",MINIFS($C$2:$C$17,$A$2:$A$17,A2))

Your forum profile says Excel 2019 - it needs updating with the information you have given.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.