Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort when I have blank cells
Hello,
I am trying to sort ascending a range containing blank cells. After sorting, the blank cells will be displayed on top and the cells woth text at the end. e.g, if I sort column A1:A10, I get B1:B10. A B C 1 1 3 2 3 4 4 2 1 5 2 6 3 6 4 5 5 6 What should I do to hace an ascending sorted range displaying the cells with text first and the empty cells at the bottom, as in C1:C10? Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort when I have blank cells
When I sorted a list of numbers, they always moved to the top.
If I sorted text, then all the really empty cells moved to the bottom. But the cells that weren't empty, but still looked blank (evaluated to ="" or a contained a space character) would sort to the top. So you could clean up those cells that look blank by hitting the delete key and really making them empty. Or you could add a helper column and use a formula that would plop in a value that would sort to the bottom. Then you could sort by that. =if(a1="","zzzzzzzzzzzz",a1) C. Corodan wrote: Hello, I am trying to sort ascending a range containing blank cells. After sorting, the blank cells will be displayed on top and the cells woth text at the end. e.g, if I sort column A1:A10, I get B1:B10. A B C 1 1 3 2 3 4 4 2 1 5 2 6 3 6 4 5 5 6 What should I do to hace an ascending sorted range displaying the cells with text first and the empty cells at the bottom, as in C1:C10? Thanks, -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
sort and sum data range with some blank cells | Excel Worksheet Functions | |||
Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
Why arent my blank cells moved to the end when I do a sort? | New Users to Excel | |||
Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions |