Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting
Create a helper column
In B1: =IF(A1="",0,A1) copy from B1 to all the way down as far as needed, Select both column A and B then sort by column B. When you done of sorting then delete column B "katymorgan" wrote: I have a spreadsheet with some blank cells in a particular column that I need to fill in. I would like to sort the rows with blank cells to the top of the spreadsheet, but no matter how I try it, Excell puts them at the bottom. Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting
Thanks mama!
"Teethless mama" wrote: Create a helper column In B1: =IF(A1="",0,A1) copy from B1 to all the way down as far as needed, Select both column A and B then sort by column B. When you done of sorting then delete column B "katymorgan" wrote: I have a spreadsheet with some blank cells in a particular column that I need to fill in. I would like to sort the rows with blank cells to the top of the spreadsheet, but no matter how I try it, Excell puts them at the bottom. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting | Excel Worksheet Functions | |||
Sorting Help | Excel Discussion (Misc queries) | |||
sorting | Excel Worksheet Functions | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
sorting help | Excel Discussion (Misc queries) |