Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |