I have a workbook that monitors duel fuel vehicles for cost analysis. At present the output screen draws all of the entries specific to the chosen vehicle number from the entered data worksheet. I have a section that sums the values of the data for entries between two chosen dates. I would like the output screen to only display the entries corresponding to the two dates in use to pre-empt the problems encountered as the entries grow.
The formula in question are in cells starting from b3,c3,d3,e3,f3,g3. The chosen dates are displayed in n1 and p1.
{=IFERROR(INDEX('ENTERED DATA'!$B$2:$H$1289,SMALL(IF(INDEX(('ENTERED DATA'!$A$2:$A$1289=$C$1)*('ENTERED DATA'!$C$2:$C$1289=$M$5),0),(ROW('ENTERED DATA'!$A$2:$A$1289)-1),""),ROW(1:1)),COLUMN(A:A)),"")}
they are array formulas. Any help appreciated.
test file attached
Bookmarks