+ Reply to Thread
Results 1 to 3 of 3

Sort list and put blank cells to bottom

  1. #1
    Forum Contributor
    Join Date
    08-04-2008
    Location
    West Calder, Scotland
    MS-Off Ver
    2010, 2016, 365
    Posts
    285

    Sort list and put blank cells to bottom

    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.

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,321

    Re: Sort list and put blank cells to bottom

    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

  3. #3
    Forum Contributor
    Join Date
    08-04-2008
    Location
    West Calder, Scotland
    MS-Off Ver
    2010, 2016, 365
    Posts
    285

    Re: Sort list and put blank cells to bottom

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1