Array is giving me a blank cell

Labrat24

New Member
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
 

Labrat24

New Member
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.
 

Some videos you may like

This Week's Hot Topics

Top