"Leo Heuser" skrev i en meddelelse
...

"Hans Knudsen" skrev i en meddelelse
...
I tried to make a custom list: A, B, C ... Z
No problem.
Then I tried to make the following list: a, b, c, ... z
but now nothing happens when I press the Import button.

I do not quite understand.

Hans Knudsen


Hej Hans

If the list is cyclic, you can enter it, starting with
a different element, i.e. make the list A, B, C ... Z.

Now you can enter the list B, C ... Z, A

Apparently Excel starts looking at the bottom list and
works its way up. The first list containing the element
entered in a cell to be dragged is being used.

E.g.

System list:

Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday

if you make this custom list:

monday
tuesday
wednesday
Thursday
Friday
Saturday
Sunday

then that's the one being used, no matter which day
you enter and drag.

Try enter friday and drag.
Then try enter Friday and drag.

!!

I run a Danish version of Excel (i.e. I have tested
the above with the Danish weekday names), but I
take it, that the principles are the same for all versions.

Med venlig hilsen
Leo




Hej Leo
Strange, but it works!
Thank you. As always - my respect for your expertise!

Hans