Auto Order?

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))),"")

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

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.