Hi! Ineed help to order by "X" colum with complicated data.
this colum have a text format. contains a book number and year like this "1542/02" book number 1542 from 2002.
how can do to order by year ? it's imposible ? i mean, first criteria must be year, later the book number.
maybe i have to change de cell format for a custom one, i try somes but get an error ..... and then the order data. uff, headake
thanks !!
What I would do is use another column to flip the data into the format that I need it. Assuming your data is in column A:
=right(A2,2)&"/"&left(A2,4)
If you run that down a column you should end up with your year first, and now it should sort by year then book.
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Bookmarks