Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting
Is it possible when you have cells with formulas in to sort them so all blank
cells appear at the bottom. I know it does this automatically when there are no formulas, but when there are it places them at the top. Thanks kevin |
#2
|
|||
|
|||
I'd use a helper cell and formulas like:
=if(b2<"",b2,rept("z",9999)) Then sort by that column. (Use a string that sorts to the bottom of your data.) Kev wrote: Is it possible when you have cells with formulas in to sort them so all blank cells appear at the bottom. I know it does this automatically when there are no formulas, but when there are it places them at the top. Thanks kevin -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
sorting non contiguous ranges | Excel Discussion (Misc queries) | |||
Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
SORTING question | New Users to Excel | |||
Adding a KeyID column for sorting | New Users to Excel |