Find the lowest scoring item in a group of items and place it on another sheet

[caliskier]

I have a task where we have several makers that make Systems with various parts. In the data sheet you can see that there are 3 makers with their models and the models have unique parts. The only unique thing about this is the parts list. The parts are also given a score which, in some rare cases, will not be unique, i.e. some parts will end up with the same score. What I have done is create a summary sheet where I have summarized the list by model and what I am looking to do is pull in that part with the lowest score, so I can say of all the parts, here is the worst one.

I have a sample excel spreadsheet I have included in this thread.

Can someone show me how I might be able to do this?

[rcm]

try the macro included

[ramananhrm]

Please try this file.

[newdoverman]

Here is another method to solve your problem.

[caliskier]

Please try this file.

Thanks very much, I was looking for a solution like this, but the problem is that for honda it puts in the lostest scored part, not for say civic. So, the civic is getting the score for the Accord for a cv joint which it does not have.

[caliskier]

All, Wow, I did not expect such a great response, I will check the other two solutions when I get back in a couple of hours. I tried to get the macro to work on the first one but it is giving me fits but I have to run and will play with it later. Thanks again, I will get back to you all.

[ramananhrm]

Please try this updated file.

[caliskier]

try the macro included

Hey this is really slick, this might work realy well. I tested it and played with it and could not find any faults.

[caliskier]

Here is another method to solve your problem.

Man this works well two... Thanks for the input. I am going to start building up my file and see what happens. Sorry I did not get back earlier, wife had about 3 more errands than I though I was going to have

[caliskier]

Please try this updated file.

Ok, I think this works better, thanks much.

Thanks all, like I say I am going to play with my file and try to get this done hopefully today. this is one of many parts I have to work on.