Results 1 to 3 of 3

sort without zeros

Threaded View

vermaccio sort without zeros 11-10-2021, 09:07 AM
Bo_Ry Re: sort without zeros 11-10-2021, 09:39 AM
vermaccio Re: sort without zeros 11-10-2021, 10:56 AM
  1. 11-10-2021, 09:07 AM #1
    vermaccio is offline
    Forum Contributor
    Join Date
    04-21-2012
    Location
    rome, italy
    MS-Off Ver
    365
    Posts
    132

    sort without zeros

    i need to sort data but zeros (zero values or empty cells) should not be sorted or they go on top of sorted datas.
    here attached an example

    thank you
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Sort and display by catagory using formulas (ignore zeros)
    By BeanyBaby in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-11-2014, 01:52 PM
  2. [SOLVED] Ignore Blank, zeros in a range sort
    By jpsnickers in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-01-2013, 02:29 PM
  3. Sort age with dateif formula - no leading zeros
    By eburt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-04-2013, 11:01 PM
  4. How do I sort data that contains to zeros to make the zeros appear at the end of the sort.
    By Sharonits in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-06-2013, 06:04 PM
  5. Sorting zeros last in accending sort.
    By JOGIER in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-22-2009, 08:09 PM
  6. Macro to sort values in list without 0's (zeros)
    By stacrafty@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2006, 08:10 AM
  7. sort numbers leading zeros
    By l smith in forum Excel General
    Replies: 2
    Last Post: 06-08-2005, 11:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1