Hello I'm trying to extract data based on the dates. For example, I want the data from my Master List to come to my October 2017 sheet only if they were in the month of October. I tried messing around with the formulas and this is what I tried and I keep getting #value. It's long but I felt like I got everything down.
I want something that could be automatic because this is a datasheet that will be constantly updated.
=IF(ROWS(A$3:A3)>$H$1,"",INDEX('Master List'!$A$4:$A$1000,SMALL(IF(('Master List'!$A$4:$A$1000>=$C$1)*('Master List'!$A$4:$A$1000<=$E$1),ROW('Master List'!$A$4:$A$1000)-ROW('Master List'!$A$4:$A$1000)+1,ROWS(A$3:A3))))
I will attached the file I'm working with.
Bookmarks