Problem with sorting a column of numbers (descending) - top two cells are blank.

[LDH]

After using the Transpose function to copy three groups of
two rows to columns, and then used the Sort function. When
selecting a group of two columns to sort, and sorting in
descending order on the second column containing the
numbers, the top two cells of the column remain blank.
There are 20 cells in the sorted column, some (10) cells
are blank, and numbers in the other cells. Why does it
not sort with the highest number in the top sorted cell?
Why is it putting two blank cells at the top then sort the
numbers descending, and put the remaining blank cells at
the bottom? Why are all of the blank cells not at the
bottom?

Needs to be sorted with all nummbers at top so the data
can be charted properly, highest to lowest, then the
blanks.

Sorry if this seems difficult to explain.

Any assistance would be appreciated.

LDH

 

[Peg]

There is probably a blank (" ") in the cells which come
to the top. The blank cells that are put on the bottom
are empty.

 

[Gord Dibben]

LDH

I can replicate this behaviour if there is a space in two of the cells that
look blank.

i.e. a descending sort will leave the two cells with a space at the top.

Clear contents of the two offending cells and try again.

Gord Dibben Excel MVP