Auto Order?

Originally Posted by azumi

Perhaps put this on cell F5 and copied down as necessary :

=IFERROR(INDEX($A$4:$A$5000,AGGREGATE(15,6,(ROW($A$4:$A$5000)-MIN(ROW($A$4:$A$5000))+1)/($A$4:$A$5000<>""),ROW(A1))),"")

That perfectly works. Thank you very much