Cod: Selectaţi tot
=IFERROR(INDEX('D:\Raport\[Ture.xlsb]Sheet'!$A$2:$W$1000;SMALL(IF(MMULT(COUNTIF($C3:$D3;'D:\Raport\[Ture.xlsb]Sheet'!$A$2:$W$1000);ROW('D:\Raport\[Ture.xlsb]Sheet'!$1:$20)/ROW('D:\Raport\[Ture.xlsb]Sheet'!$1:$20))=2;ROW('D:\Raport\[Ture.xlsb]Sheet'!$A$2:$W$1000)-1);ROWS($1:1));COLUMNS($B:C));"")