Auto Order?

Hi everyone

In rhe excel sheet in the link below in the A column there are 5k rows including untidy data.What i want to do is to get all these untidy data in order in column F.I tried a formula but could not succeed at all.Thank you very much for your help.

https://yadi.sk/i/16xRgaKM3LHLou

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.