L
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?
Sorry if this seems difficult to explain.
Any assistance would be appreciated.
LDH
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?
Sorry if this seems difficult to explain.
Any assistance would be appreciated.
LDH