How to prevent duplicate outcome in excel formula?

Hi All,

I used a formula to get the channel partner name with the lowest stock days. I applied the formula correctly, however it is giving duplicate results since the basic data of stock days is the same, but I want a different channel partner name instead of a similar result. How to Do It Could you please assist me in this?

One way:

Please try

Formula:

Please Login or Register  to view this content.

HansDouwe Thank you so much for replying to this post. However, I am attempting to extract the names of two channel partners, but your formula returns just one name when I change the Min to Max parameter. Could you kindly tell me on how we may alter this?

I used a formula to get the channel partner name with the lowest stock days.

You asked for a formula to get the name with the lowest stock days.
You didn't ask for the 2 lowest.

If you changed MIN in MAX this formula returns the name(s) with the highest stock days.
There is only 1 highest so the formula returns 1 name.

If you need the 2 highest or 2 lowest you need another formula.

This is the formula for the 2 highest:

Formula:

Please Login or Register  to view this content.

If you need the 2 lowest, please replace the 3rd sort-parameter -1 by 1.

HansDouwe Thank you so much, that is I needed!!