Google Spreadsheet Post #990
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC  Rochester Hills MI www.energyefficientbuild.com. Jan 27, 2013
user William Rafferty said:(http://productforums.google.com/forum/?zx=rq2ugebf7h4a#!categorytopic/docs/spreadsheets/3nDPfxp4UyM)
Google Spreadsheet Alphabetical Sorting Trouble
I have a spreadsheet and I would like to sort each row alphabetically according to the information in column A. The information in each row of column A is a country name. The information in each row of column B is a positive rational number.
First, I clicked the top left corner of the sheet to select all the cells. Then, from the data menu I select "Sort sheet by Column A, A to Z" Then nothing happens; my spreadsheet is unchanged.
I have also tried selecting only column A, only column A and B, right clicking and selecting "sort range", and a variety of other methods. Nothing seems to effect the order of information on the table.
If someone could explain how to do this properly I would appreciate it. Thank you.

Google Spreadsheet Alphabetical Sorting Trouble
I have a spreadsheet and I would like to sort each row alphabetically according to the information in column A. The information in each row of column A is a country name. The information in each row of column B is a positive rational number.
First, I clicked the top left corner of the sheet to select all the cells. Then, from the data menu I select "Sort sheet by Column A, A to Z" Then nothing happens; my spreadsheet is unchanged.
I have also tried selecting only column A, only column A and B, right clicking and selecting "sort range", and a variety of other methods. Nothing seems to effect the order of information on the table.
If someone could explain how to do this properly I would appreciate it. Thank you.

Post reply

This is a simple problem requiring the use of SORT function or the QUERY function ...
since the user is having a lot of trouble with it, I present an illustration as follows