ranking part numbers with cost (highest to lowest)

Originally Posted by managingcrap

Thanks for replying quickly. I just have a quick question. When I change cell D12, then, I get two of the same part numbers on cells H5 and H6. I used your sheet.

If you change value in D2 to create a duplicate, then yes. You will get two of the same part numbers as you should.