Excel Sorting "mixed data"
I have 3 columns of data that need sorting into a specific order. The
column to sort on are alpha numberics but contain letters and numbers. The
best I can do using the standard Excel sort function on the ribbon bar is:
Ideally the output should be:
AS you can see the Excel sort fucntion isnt doing the job I want it to!
Any ideas?
No comments:
Post a Comment