Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Not sorting as expected
I have a database some 10 columns wide and 1200 rows deep. When I sort by
one particular column it sorts BLANKS before text meaning that the data appears at the bottom of the database although still in alphabetical order. I have the formatting set to GENERAL for the whole column and do want the blank cells. None of the other columns do this. I am totally perplexed as I thought Excel sorted blanks nearer the end of it's priority. I have tried formatting the column to TEXT and even NUMBER also but it still makes the data appear at the bottom of the table. This doesn't make any sense to me...HELP, Thanks for any help in advance. Robbie |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Not sorting as expected
Excel always sorts blanks at the end. If blanks are sorted before text
, then the cell values may not actually be blank but may contain spaces which is regarded as text by Excel and sorted first. To overcome this, select the empty cells and press blank cells. To make sure the cells are blanks, press CTRL+G -Special-Blanks and give OK. If your cells are really blank then they would be automatically selected. For more on finding cells that contain specific values, visit this post http://xlmaster.blogspot.com/2006/08/edit-menu.thml Robbie wrote: I have a database some 10 columns wide and 1200 rows deep. When I sort by one particular column it sorts BLANKS before text meaning that the data appears at the bottom of the database although still in alphabetical order. I have the formatting set to GENERAL for the whole column and do want the blank cells. None of the other columns do this. I am totally perplexed as I thought Excel sorted blanks nearer the end of it's priority. I have tried formatting the column to TEXT and even NUMBER also but it still makes the data appear at the bottom of the table. This doesn't make any sense to me...HELP, Thanks for any help in advance. Robbie |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Not sorting as expected
Excel always sorts blanks at the end. If blanks are sorted before text
, then the cell values may not actually be blank but may contain spaces which is regarded as text by Excel and sorted first. To overcome this, select the empty cells and press blank cells. To make sure the cells are blanks, press CTRL+G -Special-Blanks and give OK. If your cells are really blank then they would be automatically selected. For more on finding cells that contain specific values, visit this post http://xlmaster.blogspot.com/2006/08/edit-menu.html - Hide quoted text - - Show quoted text - Robbie wrote: I have a database some 10 columns wide and 1200 rows deep. When I sort by one particular column it sorts BLANKS before text meaning that the data appears at the bottom of the database although still in alphabetical order. I have the formatting set to GENERAL for the whole column and do want the blank cells. None of the other columns do this. I am totally perplexed as I thought Excel sorted blanks nearer the end of it's priority. I have tried formatting the column to TEXT and even NUMBER also but it still makes the data appear at the bottom of the table. This doesn't make any sense to me...HELP, Thanks for any help in advance. Robbie |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Not sorting as expected
Mr Cools, THANK YOU for your reply. I thought I knew a little about
Excel.....how wrong. Can you tell me where I may press "BLANK CELLS" Also where SPECIAL- BLANKS is located. Thank you again, Robbie "Mr.Cools" wrote in message oups.com... Excel always sorts blanks at the end. If blanks are sorted before text , then the cell values may not actually be blank but may contain spaces which is regarded as text by Excel and sorted first. To overcome this, select the empty cells and press blank cells. To make sure the cells are blanks, press CTRL+G -Special-Blanks and give OK. If your cells are really blank then they would be automatically selected. For more on finding cells that contain specific values, visit this post http://xlmaster.blogspot.com/2006/08/edit-menu.thml Robbie wrote: I have a database some 10 columns wide and 1200 rows deep. When I sort by one particular column it sorts BLANKS before text meaning that the data appears at the bottom of the database although still in alphabetical order. I have the formatting set to GENERAL for the whole column and do want the blank cells. None of the other columns do this. I am totally perplexed as I thought Excel sorted blanks nearer the end of it's priority. I have tried formatting the column to TEXT and even NUMBER also but it still makes the data appear at the bottom of the table. This doesn't make any sense to me...HELP, Thanks for any help in advance. Robbie |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Not sorting as expected
"Robbie" wrote:
.. Can you tell me where I may press "BLANK CELLS" Also where SPECIAL- BLANKS is located. Select the range, then press F5 (or press CTRL+G, as mentioned by Mr Cools earlier). This brings up the "Go To" dialog box. In the dialog: Press "Special" button Check "Blanks" press OK. This will select only the blank cells (if any) within the range. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Sorting Sorting Sorting | Excel Discussion (Misc queries) | |||
Returning expected dates | Excel Worksheet Functions | |||
SORTING question | New Users to Excel | |||
sorting question | Excel Discussion (Misc queries) |