eadarkhorse
New Member
- Joined
- Oct 4, 2017
- Messages
- 1
Hi,
I need help with my spreadsheet.
We are trying to create something that allows the person to enter a date range, for example, Aug 1, 2017 and Aug 30, 2017 in another cell and all the calls with their details that have taken place between those dates (including both dates) should come up.
We've tried this formula but brings back too many results and not the specific date range that we want: =IFERROR(INDEX(SUMMARY!G$2:G$40,SMALL(IF(SUMMARY!$G$2:$G$40>=Sheet1!$A$2,ROW(SUMMARY!G$2:G$40)-ROW(SUMMARY!G$2)+1),ROWS(SUMMARY!G$2:SUMMARY!G2))),"")
Please see screenshot below.
Any help will be appreciated.
Regards,
Loren
I need help with my spreadsheet.
We are trying to create something that allows the person to enter a date range, for example, Aug 1, 2017 and Aug 30, 2017 in another cell and all the calls with their details that have taken place between those dates (including both dates) should come up.
We've tried this formula but brings back too many results and not the specific date range that we want: =IFERROR(INDEX(SUMMARY!G$2:G$40,SMALL(IF(SUMMARY!$G$2:$G$40>=Sheet1!$A$2,ROW(SUMMARY!G$2:G$40)-ROW(SUMMARY!G$2)+1),ROWS(SUMMARY!G$2:SUMMARY!G2))),"")
Please see screenshot below.
Any help will be appreciated.
Regards,
Loren