Extract records between dates on multiple condition

[sanjuss2]

Hi,
I am hereby attaching the file which contains sample data & 2 results
Kindly help me to extract records
1. require Docno
2. The result date change then no. of records must be as per the Originate date
3. Records must be extracted on the basis of Responded date

viz. If I run 31/03/2020
then record originate below the date must appears but if they have responded date i.e. below or equal to result date then it must be excluded.
But if the responded date is above the result date then it must be added in list as well as those records which don't have responded date must be added in list

[Richard Buttrey]

What results do you expect when the date changes and why? WHy for instance do docnos 345 & 378 feature at all for 31 March 2021?

If you want to see records for a particular date/month...whatever, why not use a Pivot Table and a Slicer to filter it.

[Bo_Ry]

Please try at H4
=IF(ROWS(H$4:H4)>$H$2,"",INDEX(A$4:A$10,SMALL(IF(($C$4:$C$10=0)+($B$4:$B$10<=$J$2)*($C$4:$C$10>$J$2),ROW(A$4:A$10)),ROWS(H$4:H4))-ROW(A$3)))

Confirm with Ctrl+Shift+Enter

[sanjuss2]

Please try at H4
=IF(ROWS(H$4:H4)>$H$2,"",INDEX(A$4:A$10,SMALL(IF(($C$4:$C$10=0)+($B$4:$B$10<=$J$2)*($C$4:$C$10>$J$2),ROW(A$4:A$10)),ROWS(H$4:H4))-ROW(A$3)))

Confirm with Ctrl+Shift+Enter

Thank you so much....