+ Reply to Thread
Results 1 to 4 of 4

Alpha Sort Rows including blanks at the bottom

  1. #1
    Forum Contributor
    Join Date
    04-22-2017
    Location
    AU
    MS-Off Ver
    Microsoft 365
    Posts
    291

    Alpha Sort Rows including blanks at the bottom

    Hello,

    I am trying to sort rows in A - Z order but include all blank cell sat the bottom.
    My attached attempt (Macro) does sort correctly but the blanks are at the top instead of the bottom.
    Would appreciate a solution please.
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Alpha Sort Rows including blanks at the bottom

    your "blank" cells are not blank
    you can sort A-Z with blank cells at the bottom if blanks cells are really blank

  3. #3
    Forum Contributor
    Join Date
    04-22-2017
    Location
    AU
    MS-Off Ver
    Microsoft 365
    Posts
    291

    Re: Alpha Sort Rows including blanks at the bottom

    Thanks sandy666.
    My terminology is incorrect.
    I still need the cells with the - in them for future use.
    How do I sort A-Z as discussed above with these - included at the bottom please?

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Alpha Sort Rows including blanks at the bottom

    two steps:
    - select all then sort by Z-A
    - select range without "-" sign and sort by A-Z
    maybe someone else will give you a formula or vba solution to sort with one step

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How can i sort rows with alpha numeric values to the top
    By santnair0599 in forum Excel General
    Replies: 5
    Last Post: 04-21-2016, 12:44 PM
  2. Replies: 2
    Last Post: 09-26-2014, 04:28 PM
  3. [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
  4. 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
  5. How to Sort Numerically prefixed alpha numeric rows by Number
    By Shullay in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-25-2012, 08:36 PM
  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. [SOLVED] Sort by Alpha, ignore blanks
    By ufo_pilot in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-04-2006, 09:35 AM

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