How do I find the 2nd smallest value in a column only if they are in the top 50% of sales?

I have a table in Excel that shows the % change of sales YOY by agent, I need to be able to quickly point out who has the 2nd smallest change but ONLY if they are in the top 50% of sales, I was able to use MINIFS to find the smallest by saying =MINIFS($A:$A,$B:$B,”<.5″,$B:$B,”>0″) where A is the % change and B indicates % of sales. I can’t seem to find a way to use this type of logic to find the 2nd or 3rd smallest, if B<.5 what is the 2nd smallest amount in column A? Any help would be appreciated!