Custom sort list issue [Excel 2011 for Mac]

So I've got a worksheet going and I've tried to create a custom list to sort from. Everything appears to be working as specified except when I get to a certain value [4" and up] and then it goes wonky on me. Here's some screens of the data I'm working with and my list I've created. I can provide a sample spreadsheet if needed. What's weird is that it sorts fine in the pivot table but not in the worksheet that's driving it. Any ideas on how to fix this minor issue? It's not a huge deal but it bothers me enough to want to fix it. I've tried recreating the list several times entering the data in other worksheets but I can't seem to get it to act right. Any help would be greatly appreciated.

The input list is on the right.

Edit: attached file

Screen Shot 2016-08-01 at 5.11.44 PM.pngScreen Shot 2016-08-01 at 5.13.25 PM.png

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Thanks for the reply. I'll fix the original post.

Hi,

It appears to me to be a 255 character limitation on the length of the custom list. Even though the entire list appears to be in place, only the first 255 characters - which unfortunately includes the comma and space separators which you see when applying the list to the sort - appear to be used when sorting on the sheet.

No, I do not. However you could add a formula column that matches the length in each row against your list and then sort by that column.

You may add a new column with this formula
=MATCH(C2,Inputs!$A$1:$A$40,0)
If you sort on this column, it will sort your length column in the order you want.