Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: sort function

  1. #1
    Board Regular
    Join Date
    May 2002
    Location
    CALIFORNIA
    Posts
    137
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    does anyone know a good sort function.
    I've tryed the built in one and one I got out of a book but they dont work right.

    When I'm sorting data in a column it doesn't handle blanks the way I want it to.
    It wont always sink the blanks, it will leave the blanks at the bottom if they're already there, but not sink the ones in the middle of data.

    example
    4
    3

    6
    8
    1

    7
    It leaves these blanks in the same spots but it sorts the data


    thanks for any help

    steve w

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-12 08:47, white6174 wrote:

    does anyone know a good sort function.
    I've tryed the built in one and one I got out of a book but they dont work right.

    When I'm sorting data in a column it doesn't handle blanks the way I want it to.
    It wont always sink the blanks, it will leave the blanks at the bottom if they're already there, but not sink the ones in the middle of data.

    example
    4
    3

    6
    8
    1

    7
    It leaves these blanks in the same spots but it sorts the data


    thanks for any help

    steve w
    Hi Steve,

    no, this doesn't sound right at all.

    You're definitely sorting on that specific column ?

    Are those blank cells actually blank ? Somebody hasn't sneakily changed the contents' font colour to white to make them look like they're blank, have they ?

    can you also just check a few of them : interrogate them with =ISBLANK(cell) where cell is the cell reference

    if they're blank, the results should be "FALSE"


    :: Pharma Z - Family drugstore ::

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Chris these cellsmust no be blanks else sort will shuffle to bottom regardless..

    your call is spot on... could be many reasons

    fastes fix i wold say is:

    simply autofilter the colm to blanks and clear contence not delete or clean up and them re try.. forget the reasons if they are set to blank/ enpty call as you do sort can not fail.


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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