I agree with everything you wrote--except one thing:

A practical example:

<vvbg

Leo Heuser wrote:

I wasn't focused on the use of lists for sorting,
but for filling ranges.
My point was, that it *is* possible to create a
list having the same elements as a current list,
by starting with a different element, and if
needed combining it with a difference in case.

A practical example:

Let's assume that a (Danish) user wants to put
emphasis on saturday and sunday by letting the
names consist of upper case letters only (SATURDAY
and SUNDAY) (in Denmark weekday names start
with a lower case letter).

She has to enter weekday names in e.g. A2 and down.

Try the following examples without quotes:

1. Enter "SUNDAY" in A2 and drag down
2. Enter "sunday" in B2 and drag down
3. Enter "Sunday" in C2 and drag down
4. Enter "monday" or ... in D2 and drag down

Everything turns out as expected.

Now create the list

SUNDAY
monday
tuesday
wednesday
thursday
friday
SATURDAY

If the system list starts with Sunday, make it this list instead:

monday
tuesday
wednesday
thursday
friday
SATURDAY
SUNDAY

Make the same dragging movements <g in F2,
G2, H2 and i2

I guess, this wasn't expected <g

"Dave Peterson" skrev i en meddelelse
...
But these are different lists. You can see it when you sort test data
using
each list. (Yes, you could sort any data by each list (ignoring the B, C,
...,
Z, A version).

But if excel ignores the case in the list and uses the case in the data
(for
filling the range), I guess I'd question the use of having two lists.

Leo Heuser wrote:

"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

--

Dave Peterson

--

Dave Peterson