Good Morning Folk
Is there a way to sort a list of names alphabetically and put any blank cells to the bottom rather than the top
Cheers Jim
Good Morning Folk
Is there a way to sort a list of names alphabetically and put any blank cells to the bottom rather than the top
Cheers Jim
Last edited by JamesT1; 05-19-2011 at 12:21 PM.
thats how mine sorts anyway! numbers first then text then blanks
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hi Guys
The way I solved this was,,,,,,
The list I am sorting is linked to a master list on another spreadsheet... if the master list cell was blank then my list inserted ZZZ, I used Conditional Formatting to make these the same colour as the background,,, then when I sorted the list it put everything into the order I wanted with the ZZZ's at the bottom
Cheers
Jim
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks