Sorting lists of Named Ranges
 

Hi!

I have a sheet all with Named Ranges in it which behaves strangely when
sorting (Excel 2000).

I get the same result if creating a new fresh file to test. For instance:
1) Create a sheet with the letters A, B, C, D, E, F in column A, rows 1-6
2) Name A1:A6 "Letters"
3) Create a second sheet, and put the formula "=Letters" in A1:A6
4) Select A1:A6 and sort on it ascending - fine
5) Now sort on it descending - and it comes out A, E, D, C, B, F ?!

I've also noticed that if you repeat sorting enough times, adjacent columns
will become out of sync.

Anyone have any idea why this is happening and what the workaround is?

Brgds

Danny

Sorting lists of Named Ranges
 

When you say sort on A1:A6, on the original sheet or on the sheet with the
=Letters formula.

In any event, I couldn't reproduce your problem in xl2000.

--
Regards,
Tom Ogilvy

"Daniel Magnus Bennét Björck" wrote in message
...
Hi!

I have a sheet all with Named Ranges in it which behaves strangely when
sorting (Excel 2000).

I get the same result if creating a new fresh file to test. For instance:
1) Create a sheet with the letters A, B, C, D, E, F in column A, rows 1-6
2) Name A1:A6 "Letters"
3) Create a second sheet, and put the formula "=Letters" in A1:A6
4) Select A1:A6 and sort on it ascending - fine
5) Now sort on it descending - and it comes out A, E, D, C, B, F ?!

I've also noticed that if you repeat sorting enough times, adjacent
columns
will become out of sync.

Anyone have any idea why this is happening and what the workaround is?

Brgds

Danny

Sorting lists of Named Ranges
 

Hi!

I mean the sheet with the "=Letters" formulas.

I've tried it several times with newly created workbooks, different values,
selections, and everything, and keep getting the same result.

Others in the same company are also getting incorrect sorting, especially
under Excel 97.

Brgds

Danny

"Tom Ogilvy" wrote in message
...
When you say sort on A1:A6, on the original sheet or on the sheet with the
=Letters formula.

In any event, I couldn't reproduce your problem in xl2000.

--
Regards,
Tom Ogilvy

"Daniel Magnus Bennét Björck" wrote in message
...
Hi!

I have a sheet all with Named Ranges in it which behaves strangely when
sorting (Excel 2000).

I get the same result if creating a new fresh file to test. For
instance:
1) Create a sheet with the letters A, B, C, D, E, F in column A, rows
1-6
2) Name A1:A6 "Letters"
3) Create a second sheet, and put the formula "=Letters" in A1:A6
4) Select A1:A6 and sort on it ascending - fine
5) Now sort on it descending - and it comes out A, E, D, C, B, F ?!

I've also noticed that if you repeat sorting enough times, adjacent
columns
will become out of sync.

Anyone have any idea why this is happening and what the workaround is?

Brgds

Danny

Sorting lists of Named Ranges
 

When you define the name letters do you have

=Sheet1!$A$1:$A$6

as the refers to, including the $

if not, then that might be your problem. You need to use absolute
references.

--
Regards,
Tom Ogilvy


"Daniel Magnus Bennét Björck" wrote in message
...
Hi!

I mean the sheet with the "=Letters" formulas.

I've tried it several times with newly created workbooks, different
values,
selections, and everything, and keep getting the same result.

Others in the same company are also getting incorrect sorting, especially
under Excel 97.

Brgds

Danny

"Tom Ogilvy" wrote in message
...
When you say sort on A1:A6, on the original sheet or on the sheet with
the
=Letters formula.

In any event, I couldn't reproduce your problem in xl2000.

--
Regards,
Tom Ogilvy

"Daniel Magnus Bennét Björck" wrote in
message
...
Hi!

I have a sheet all with Named Ranges in it which behaves strangely
when
sorting (Excel 2000).

I get the same result if creating a new fresh file to test. For
instance:
1) Create a sheet with the letters A, B, C, D, E, F in column A, rows
1-6
2) Name A1:A6 "Letters"
3) Create a second sheet, and put the formula "=Letters" in A1:A6
4) Select A1:A6 and sort on it ascending - fine
5) Now sort on it descending - and it comes out A, E, D, C, B, F ?!

I've also noticed that if you repeat sorting enough times, adjacent
columns
will become out of sync.

Anyone have any idea why this is happening and what the workaround is?

Brgds

Danny

Sorting lists of Named Ranges
 

Hi!

Yes, that's exactly what I have, Sheet1!$A$1:$A$6.

Brgds

Danny

"Tom Ogilvy" wrote in message
...
When you define the name letters do you have

=Sheet1!$A$1:$A$6

as the refers to, including the $

if not, then that might be your problem. You need to use absolute
references.

--
Regards,
Tom Ogilvy


"Daniel Magnus Bennét Björck" wrote in message
...
Hi!

I mean the sheet with the "=Letters" formulas.

I've tried it several times with newly created workbooks, different
values,
selections, and everything, and keep getting the same result.

Others in the same company are also getting incorrect sorting,
especially
under Excel 97.

Brgds

Danny

"Tom Ogilvy" wrote in message
...
When you say sort on A1:A6, on the original sheet or on the sheet with
the
=Letters formula.

In any event, I couldn't reproduce your problem in xl2000.

--
Regards,
Tom Ogilvy

"Daniel Magnus Bennét Björck" wrote in
message
...
Hi!

I have a sheet all with Named Ranges in it which behaves strangely
when
sorting (Excel 2000).

I get the same result if creating a new fresh file to test. For
instance:
1) Create a sheet with the letters A, B, C, D, E, F in column A,
rows
1-6
2) Name A1:A6 "Letters"
3) Create a second sheet, and put the formula "=Letters" in A1:A6
4) Select A1:A6 and sort on it ascending - fine
5) Now sort on it descending - and it comes out A, E, D, C, B, F ?!

I've also noticed that if you repeat sorting enough times, adjacent
columns
will become out of sync.

Anyone have any idea why this is happening and what the workaround
is?

Brgds

Danny

Sorting lists of Named Ranges
 

I have sent the Excel example detailed to many people, and all are getting
the exact same result, using either Excel 97 or Excel 2000. Can I send it to
you privately so you can have a look at it yourself?

Brgds

Danny

"Tom Ogilvy" wrote in message
...
When you say sort on A1:A6, on the original sheet or on the sheet with the
=Letters formula.

In any event, I couldn't reproduce your problem in xl2000.

--
Regards,
Tom Ogilvy

"Daniel Magnus Bennét Björck" wrote in message
...
Hi!

I have a sheet all with Named Ranges in it which behaves strangely when
sorting (Excel 2000).

I get the same result if creating a new fresh file to test. For
instance:
1) Create a sheet with the letters A, B, C, D, E, F in column A, rows
1-6
2) Name A1:A6 "Letters"
3) Create a second sheet, and put the formula "=Letters" in A1:A6
4) Select A1:A6 and sort on it ascending - fine
5) Now sort on it descending - and it comes out A, E, D, C, B, F ?!

I've also noticed that if you repeat sorting enough times, adjacent
columns
will become out of sync.

Anyone have any idea why this is happening and what the workaround is?

Brgds

Danny