How to extract the list from Master data between two dates - Situation differs ..

Hi,
use this array formula in M4 and drag across

Formula:

=IFERROR(INDEX($A$4:$J$63,SMALL(IF(($B$4:$B$63>=$N$1)*($B$4:$B$63<=$N$2)*($J$4:$J$63<>"")>0,ROW($C$4:$C$63)-3),ROWS($1:1)),COLUMNS($A:A)),"")

Thanks a lot Mr. Jason, Ms. Ali and Mr. TubyBTH for your help and teaching. Really made a insight and curious to learn so much in ARRAY formula.

Million Thanks