Sorting lists of Named Ranges

  • Thread starter Thread starter Daniel Magnus Bennét Björck
  • Start date Start date
D

Daniel Magnus Bennét Björck

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
 
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.
 
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
 
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.
 
Hi!

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

Brgds

Danny
 
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
 
Back
Top