Hello,

i would like to implement sorting text cells using array formula in excel in the current formula. Can somebody help me please ?

=IF($C$2=0,"",IFERROR(INDEX('Team Leader Input Table'!$F$7:$F$270, SMALL(IF($C$2='Team Leader Input Table'!$D$7:$D$270, ROW('Team Leader Input Table'!$D$7:$D$270)-ROW('Team Leader Input Table'!$D$7)+1), ROW(1:1))),"No Info" ))
Thank you very much in advance.