SPECIAL NUMBER SORTING
I am trying to sort a spreadsheet with special numbers. it puts 129.01.00A ahead of 13.01.00, 71.01.00 etc. I want it to sort by the number ahead of the first decimal, then by the second, etc. e.g. 13.01.00 then 71.01.00 then 129.01.00A I have tried formatting by number, by general, by accounting. Any help appreciated.
Sorting data - by reference
Hi I have data set like this; Date Reference 28/11/2017 119737 28/01/2018 119737 28/02/2018 119737 28/03/2018 119737 07/09/2017 119787 07/10/2017 119787 07/11/2017 119787 07/12/2017 119787 07/01/2018 119787 07/02/2018 119787 07/03/2018 119787 28/09/2017 119807 28/11/2017 119807 28/09/2017 119839 28/10/2017 119839 28/11/2017 119839 28/12/2017 119839 28/01/2018 119839 28/02/2018 119839 28/03/2018 119839 01/10/2017 119931 01/11/2017 119931 01/01/2018 119931 01/02/2018 119931 I need to split the references /dates to different CSV files as one file cant have duplicate references. Im currently filtering and numbering, then will move all 1's, all 2's etc. Is there a quicker way to do this? Thanks :)
