| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named Ranges | Excel Worksheet Functions | |||
| How do I use Named Ranges as Data Validation Lists? | Excel Worksheet Functions | |||
| Named Ranges | Excel Discussion (Misc queries) | |||
| Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
| Named Ranges | Excel Worksheet Functions | |||
Hybrid Mode
