Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Would like to sort data in spreadsheet with empty cells
I am using Excel 2002, and would like to sort an area (colums B thru AD and
rows 7 thru 22). The data is set up as follows: Column B Column C Column D etc. Row 7 Nielsen Sarah Row 8 Missing info Row 9 Missing signature Row 10 Smith John Row 11 Need follow-up Row 12 Doe Susan etc. The following rows may or may not have any information in them. I am trying to sort the data by column B (last name) and have the remaining columns follow. My problem is that the rows with nothing in them will sort to the end of the tabel and that is not right. Can I do this in any way? PS. I am a novice, and have tried looking at some of the answers but did not quite get the answers as they were mostly in programming - will it be possible to get an answer for dummies? :) -- Regards, Anja |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Would like to sort data in spreadsheet with empty cells
Anja, Here is a technique from John Walkenbach that prepares the data so it can be sorted... http://j-walk.com/ss/excel/usertips/tip040.htm -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Anja" wrote in message I am using Excel 2002, and would like to sort an area (colums B thru AD and rows 7 thru 22). The data is set up as follows: Column B Column C Column D etc. Row 7 Nielsen Sarah Row 8 Missing info Row 9 Missing signature Row 10 Smith John Row 11 Need follow-up Row 12 Doe Susan etc. The following rows may or may not have any information in them. I am trying to sort the data by column B (last name) and have the remaining columns follow. My problem is that the rows with nothing in them will sort to the end of the tabel and that is not right. Can I do this in any way? PS. I am a novice, and have tried looking at some of the answers but did not quite get the answers as they were mostly in programming - will it be possible to get an answer for dummies? :) -- Regards, Anja |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Would like to sort data in spreadsheet with empty cells
Thanks for the quick responce, unfortunately I am having some problems with
the process. When I click the BLANKS option I have to click OK and then the screen disappears. Where should I write the =B17? (That would be step # 5). -- Regards, Anja "Jim Cone" wrote: Anja, Here is a technique from John Walkenbach that prepares the data so it can be sorted... http://j-walk.com/ss/excel/usertips/tip040.htm -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Anja" wrote in message I am using Excel 2002, and would like to sort an area (colums B thru AD and rows 7 thru 22). The data is set up as follows: Column B Column C Column D etc. Row 7 Nielsen Sarah Row 8 Missing info Row 9 Missing signature Row 10 Smith John Row 11 Need follow-up Row 12 Doe Susan etc. The following rows may or may not have any information in them. I am trying to sort the data by column B (last name) and have the remaining columns follow. My problem is that the rows with nothing in them will sort to the end of the tabel and that is not right. Can I do this in any way? PS. I am a novice, and have tried looking at some of the answers but did not quite get the answers as they were mostly in programming - will it be possible to get an answer for dummies? :) -- Regards, Anja |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Would like to sort data in spreadsheet with empty cells
You should have already selected all of the column data in Step 1. So you don't worry about where to type it, just type (write) the formula using the keyboard. Jim Cone "Anja" wrote in message Thanks for the quick responce, unfortunately I am having some problems with the process. When I click the BLANKS option I have to click OK and then the screen disappears. Where should I write the =B17? (That would be step # 5). -- Regards, Anja |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Would like to sort data in spreadsheet with empty cells
Thank you so much for your help!
-- Regards, Anja |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting data €“ when some cells are empty | Excel Discussion (Misc queries) | |||
Removing empty cells from spreadsheet data | Excel Discussion (Misc queries) | |||
Count Only Empty Cells AFTER Cells with Data | Excel Worksheet Functions | |||
Can I sort excel spreadsheet data by fill color of cells? | Excel Discussion (Misc queries) | |||
data in empty cells | Excel Worksheet Functions |