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, |
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 |
All times are GMT +1. The time now is 10:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com