Hi all,
I have a list of dates with an extra number in the back that I would like to sort.
Data example :
So basicly excel should first need to sort on the year (last 2 numbers before the "-" ), then the month (middle 2 numbers), then the day (first 2 numbers) and finally the number in the back.![]()
Please Login or Register to view this content.
The only way out I found so far was to make extra columns (or arrays using vba) with the split info and then sort those, thus sorting this. But i'd like to know if there's some way to do it in 1 formula kind of thing.
Thanks in advance
Bookmarks