+ Reply to Thread
Results 1 to 2 of 2

Sort blanks to bottom

  1. 03-15-2018, 06:34 PM #1
    xcracer41
    xcracer41 is offline
    Registered User
    Join Date
    10-30-2017
    Location
    United States
    MS-Off Ver
    2016
    Posts
    20

    Sort blanks to bottom

    Evert time I sort a list with the largest values on top, all the blanks show up at the top. Is there a way to put them on the bottom?
    Reply With QuoteRegister To Reply
  2. 03-16-2018, 04:40 AM #2
    noboffinme
    noboffinme is offline
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: Sort blanks to bottom

    Hi xcracer41,

    That's not how Excel would normally work as I'm guessing you already know.

    Is there any old data that had been deleted from these blank Cells?

    Could you copy the List data & paste it 'Special Values' into a new worksheet & see if that sorts normally?

    One other option is to copy & paste the list data into Notepad & the paste it back into Excel.

    Otherwise, can you post your data so I can see why it may be doing this?
    Remember you are unique, like everyone else
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Alpha Sort Rows including blanks at the bottom
    By VisionSmart in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-22-2017, 03:47 AM
  2. sort data into a different column using a formula and putting blanks at the bottom
    By hengland in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-26-2014, 04:28 PM
  3. [SOLVED] Help with sorting cells and put blanks at the bottom
    By markharris2004 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-12-2014, 02:34 AM
  4. [SOLVED] Help with a macro to delete empty (but not blank) cells OR sort blanks to the bottom
    By Cyali in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2012, 09:04 PM
  5. Referenced sheet, automatically sort (alpha) and send blanks to the bottom.
    By jw586 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2012, 10:48 AM
  6. Linked Sheets, Sort Cells, Blanks to bottom
    By Rivian in forum Excel General
    Replies: 2
    Last Post: 09-13-2009, 01:14 PM
  7. How NOT to Sort Blanks that aren't Blanks
    By Tirren in forum Excel General
    Replies: 1
    Last Post: 08-17-2009, 01:45 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1