Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have problem with a small database - it will not sort.
That is, it DOES change the data around, but not in any comprehensible way. Having selected the database block, I requested "sort" on last column, expecting to see a descending numeric order. I got garbage. I cannot determine exactly what the order is, but it's certainly neither numeric nor alpha. At least the "garbage" will "Undo" (reverts to original) Nor is it related to the underlying reference cells which yield the number Data Sort option is (correctly) set to sort "top to bottom" in descending order - expected result, the data re-presented with last column in decending order from 18 to 0. .. Construction - 11 columns x 39 rows. No blank columns, rows or cells.. 1st 2 columns are text (names), the remaining 9 are all numbers ranging from 0 to 18. There are NO column headers. All the numeric cells are identically sized. There are no merged cells. All the numbers are calculated or derived from elsewhere in the spreadsheet, i.e all function results or additions of disparate cells. All are valid - no hashes/errors. I've tested "sort" on a straightforward set of number columns - it works fine, on single "direct-keyed" nuimbers ! HELP please. Len |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - data autofilter, then data sort how do you view all | Excel Discussion (Misc queries) | |||
Excel data sort | Excel Worksheet Functions | |||
data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
I want to convert word column data to excel row data to sort addre | Excel Discussion (Misc queries) | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) |