Nu reusesc sa aplic inca o conditie in actuala formula perfect functionala de jos:
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));"")
Sa adaug si aceasta conditie de jos in formula de sus:
Cod: Selectaţi tot
IF(AND($B$2>=TIMEVALUE("10:00:00"))*($B$1000<=TIMEVALUE("18:00:00"))
Sa caute pe langa COUNTIF($C3:$D3 si in coloana B privind intervalul dorit de cautare.
Sarbatori fericite si Craciun fericit!