ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cannot sort data (https://www.excelbanter.com/excel-discussion-misc-queries/256209-cannot-sort-data.html)

Bill

Cannot sort data
 
Have a column of numbers which are formatted as numbers.
Cannot sort the numbers from largest to smallest or vice versa.
"Order" section of "Sort" in Data Tab does not indicate an option for
largest to smallest or vice versa.

Any suggestions?

Russell Dawson

Cannot sort data
 
It says A-Z or Z-A. It doesn't mean it will only sort text. It's to give
you the opportunity to select highest to lowest and vice versa.
--
Russell Dawson
Excel Student


"Bill" wrote:

Have a column of numbers which are formatted as numbers.
Cannot sort the numbers from largest to smallest or vice versa.
"Order" section of "Sort" in Data Tab does not indicate an option for
largest to smallest or vice versa.

Any suggestions?


Gord Dibben

Cannot sort data
 
I thought we sorted this out yesterday.

On Thu, 11 Feb 2010 20:30:01 -0800, Bill
wrote:

Gord:

It worked.

Thanks,

Bill



Gord

On Fri, 12 Feb 2010 23:28:01 -0800, Bill
wrote:

Have a column of numbers which are formatted as numbers.
Cannot sort the numbers from largest to smallest or vice versa.
"Order" section of "Sort" in Data Tab does not indicate an option for
largest to smallest or vice versa.

Any suggestions?




All times are GMT +1. The time now is 09:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com