In excel 2010 (on a W7 64-bit machine), I have created the following custom list:
Benzene
Toluene
Ethylbenzene
Total Xylenes
MTBE
Benzo(a)anthracene
Benzo(a)pyrene
Benzo(b)fluoranthene
Benzo(k)fluoranthene
Chrysene
Dibenz(a,h)anthracene
Indeno(1,2,3-cd)pyrene
Naphthalene
Problem is, when I select a range to sort, the results are out of order, like this (the last 3 entries are out of order):
Benzene
Toluene
Ethylbenzene
Total Xylenes
MTBE
Benzo(a)anthracene
Benzo(a)pyrene
Benzo(b)fluoranthene
Benzo(k)fluoranthene
Chrysene
Naphthalene
Dibenz(a,h)anthracene
Indeno(1,2,3-cd)pyrene
Odd thing is, when I go to the custom list dialogue box & highlight my custom list, the list is displayed in the correct order in the "List Entries" window. Even more odd, is if I type the 1st list entry (i.e. benzene) in a cell and drag down, the list will auto fill correctly.
I have tried deleting the list, restarting excel, and recreating the list to no avail. There are no other custom lists (other than the 4 default excel lists) displayed in the custom list dialogue.
Does anyone have any insight as to how I could sort (HA - pun!) this out?
Thanks in advance,
Lucas
Bookmarks