Display all data within Start and end date

Hi All,

I can't resolve the following problem:

I've got a start and end date in resp cell A2 and B2.

Beneath these cells I've sorted some dates with matching data.

Does someone know how I can display all the dates with their matching data which are in the selected interval? I want to prevent blank cells, maybe something with an array function?

Thnx in advance!!

help.xlsx

My bad! You are right!, I'm going to try i right away! Thnx

Originally Posted by benishiryo

hi spangpang. try this array formula in E5:

Formula:

=IFERROR(INDEX(A$4:A$16,SMALL(IF($A$4:$A$16>=$A$2,IF($A$4:$A$16<=$B$2,ROW($A$4:$A$16)-ROW($A$4)+1)),ROWS(E$5:E5))),"")

drag down & across. question: why is A11:B11 excluded? isnt it within the date?

Put this formula in C4:

Formula:

=IF(AND(A4>=A$2,A4<=B$2),MAX(C$3:C3)+1,"-")

and copy down to the bottom of your data. Then you can get the first date using this formula:

Formula:

=IFERROR(INDEX(A:A,MATCH(ROWS($1:1),$C:$C,0)),"")

and the corresponding name using this in the adjacent cell:

Formula:

=IFERROR(INDEX(B:B,MATCH(ROWS($1:1),$C:$C,0)),"")

(actually, this is just the previous formula copied into it).

Format the date cell as you wish to see it, then copy these two formulae down as far as you need to. Then change the start or end dates on row 2 and the list will automatically adjust.

Not sure why you are not showing the Tupolev flight on 6th April in your list.

Hope this helps.

Pete

Thank you for the effor! I've solved it now with the help you provided!