Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort fails on one column
I've been working with a spreadsheet, using different sorts on it. But
suddenly one of the columns became a no-op for sorting, whether I sort on that column alone or do a multi-column sort. The only thing I did of interest was to define a pulldown list (for a different column) in a column over at the right, which is outside of the sort range. To be specific, I highlight columns A-J to sort, and J is the one that doesn't work. Columns L-M are used to define pulldowns, but not for column J. Any ideas? -- Christopher Brewster Lockheed Martin, Eagan MN Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort fails on one column
I got this to work but don't understand it. I moved my pulldown definition to
another sheet, and the sheet with the problem then sorted correctly. I moved the pulldown definition back to where it had been, and the sorting was still correct. So it had something to do with the pulldown definition, but I don't know what. christophercbrewster wrote: I've been working with a spreadsheet, using different sorts on it. But suddenly one of the columns became a no-op for sorting, whether I sort on that column alone or do a multi-column sort. The only thing I did of interest was to define a pulldown list (for a different column) in a column over at the right, which is outside of the sort range. To be specific, I highlight columns A-J to sort, and J is the one that doesn't work. Columns L-M are used to define pulldowns, but not for column J. Any ideas? -- Christopher Brewster Lockheed Martin, Eagan MN Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201005/1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort fails on one column
Help! The sort is broken again, even with all pulldown definitions removed.
Anyone know what can prevent a sort from happening? christophercbrewster wrote: I've been working with a spreadsheet, using different sorts on it. But suddenly one of the columns became a no-op for sorting, whether I sort on that column alone or do a multi-column sort. The only thing I did of interest was to define a pulldown list (for a different column) in a column over at the right, which is outside of the sort range. To be specific, I highlight columns A-J to sort, and J is the one that doesn't work. Columns L-M are used to define pulldowns, but not for column J. Any ideas? -- Christopher Brewster Lockheed Martin, Eagan MN Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201005/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-Sort Won't Sort All Column Cells | Excel Discussion (Misc queries) | |||
data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
moving column/cell data to rows/cells fails | Excel Worksheet Functions | |||
How can I sort one column and have the entire row sort. (binding) | Excel Worksheet Functions | |||
In Excel, why sort function fails when applied to a list of date? | Excel Discussion (Misc queries) |