Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Sort Descending, zero and blanks at the bottom of the list

  1. #1
    Board Regular
    Join Date
    May 2006
    Location
    California
    Posts
    111
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Sort Descending, zero and blanks at the bottom of the list

    I am having trouble with a sort. I would like a list sorted descending, so that the highest dollar amount is at the top. However, if there are blanks or zeros in the list, it is putting those first. How do I get it to ignore them or put them at the bottom?

    Thank you,
    Liz

  2. #2
    Board Regular Erdinç E. Karaçam's Avatar
    Join Date
    Sep 2006
    Location
    Bursa - Türkiye
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Sort Descending, zero and blanks at the bottom of the list

    Try this formula in the next column;

    i.e.:
    CELL: B1
    Code:
    =IF(OR(ISEMPTY(A1),A1=0),"","Sort")
    And copy down

    And, filter column B, By: Sort

    And finally sort by desceding column A.
    Erdinç E. Karaçam
    Excel 2010 TURKISH
    KINDLY GREETINGS FROM THE COUNTRY OF LOVE AND PEACE
    BURSA | TÜRKİYE

  3. #3
    Board Regular
    Join Date
    May 2006
    Location
    California
    Posts
    111
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Sort Descending, zero and blanks at the bottom of the list

    Thank you. This worked.

    Liz

  4. #4
    Board Regular Erdinç E. Karaçam's Avatar
    Join Date
    Sep 2006
    Location
    Bursa - Türkiye
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Sort Descending, zero and blanks at the bottom of the list

    Quote Originally Posted by lsteffen View Post
    Thank you. This worked.

    Liz
    You are welcome Liz.
    Erdinç E. Karaçam
    Excel 2010 TURKISH
    KINDLY GREETINGS FROM THE COUNTRY OF LOVE AND PEACE
    BURSA | TÜRKİYE

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
  •