=ИНДЕКС($A$2:$A$9;АГРЕГАТ(15;6;(СТРОКА($A$2:$A$9)-1)/($C$2:$C$9>=0)/($B$2:$B$9=$B$2);СТРОКА(A1)))
=IFERROR(INDEX(A$2:A$90;AGGREGATE(15;6;ROW($1:$150)/(C$2:C$90=D2)/(B$2:B$90="конкурентная");COUNTIF(D$2:D2;D2)));"")