Формула
Код |
---|
=IFERROR(INDEX($B2:$B9;AGGREGATE(15;6;ROW($1:$100)/($H2=$A$2:A$100)/(I$1>=$C$2:$C$100)/(I$1<=$D$2:D$100);1));"") |
Изменено: jakim - 26 янв 2021 16:31:21