Hi Guys,

I'm working with an array formula (see below) that searches for and organises a particular value (in this case System Name) based on the date that it is due to finish. The formula works fine, but I am trying to set it up in such a way that the results appear at the bottom of the chart, as opposed to the top. I've attached the file in question for clarity.....any assistance would be greatly appreciated.

=IF(ROW()-ROW(T$3:T$23)+1>ROWS(G$3:G$28)-COUNTBLANK(G$3:G$28),"",INDIRECT(ADDRESS(SMALL((IF(G$3:G$28<>"",ROW(G$3:G$28),ROW()+ROWS(G$3:G$28))),ROW()-ROW(T$3:T$23)+1),COLUMN(G$3:G$28),4)))




SC Skyline Rev 01.xls