Retrun all rows from a table if criteria is met

[Chris.Williams81]

I am keeping a company forecasting spreadsheet and regularly need to extract information from the data based on certain criteria.

For example I want to find all Expenses that occurred in January 2015. Therefore exclude all other month's. Any expense that has an end date before Jan 2015 or has a start date after Jan 2015 would be excluded. At the moment I am able to do this using the filters which is perfect but time consuming. Would it be possible to create another page on the workbook where all entries are returned if certain criteria is met?

What would be the quickest way of extracting information from the spreadsheet? See the spreadsheet attached.

[AlKey]

Enter this formula on Sheet2 in cell B2. Pull formula to the right and then down. Format columns E and F as Date.

=IFERROR(INDEX(Sheet1!B:B,AGGREGATE(15,6,ROW(Sheet1!$C$2:$C$4045)/((Sheet1!$C$2:$C$4045=$K$3)*(Sheet1!$E$2:$E$4045>=$K$4)*(Sheet1!$E$2:$E$4045<=$K$5)),ROWS(B$2:B2))),"")

[canapone]

Hi,

in B2 to be copied across


=iferror(index(Sheet1!B$2:B$4045,aggregate(15,6,row($2:$4045)-1/((Sheet1!$C$2:$C$4045=$K$3)*(Sheet1!$E$2:$E$4045>=$K$4)*(Sheet1!$F$2:$F$4045<=$K$5)),rows($A$1:$A1))),"")


-------------------------------


edit: excuse me Alkey, I did not mean to overlap: same approach.

[Chris.Williams81]

Perfect, thank you