Array is giving me a blank cell

[Labrat24]

I have an array that takes two lists of dates that are in the same column and re-organizes them in chronological order and ignores blank cells that are a result of a gap in the two lists. For some reason it is completely ignoring one data point and giveing me a blank intead on row 101. I have coppied the array below.

=INDEX($AI$5:$AI$200,MATCH(ROWS($AI$5:AI5),COUNTIF($AI$5:$AI$200,"<="&$AI$5:$AI$200),0))

Thanks in advance

 

[steve the fish]

Cant you just use small or have i missed something?

=SMALL($AI$5:$AI$200,ROWS($A$1:A1))

 

[Labrat24]

The problem with using that is it gives me #NUM ! instead of #N/A which causes problem with my graph.

 

[steve the fish]

Num should only happen at the end? Just use the range before the error occurs.

 

[Labrat24]

The problem with that is there are 10s of graphs using these dates so it could take me hours to update all graphs when now I don’t have to update them at all when new data is generated.