+ Reply to Thread
Results 1 to 1 of 1

Excel 2007 : Sorting including empty cells

Hybrid View

  1. #1
    Registered User
    Join Date
    03-01-2011
    Location
    Greece
    MS-Off Ver
    Excel 2007
    Posts
    1

    Sorting including empty cells

    I'm having a problem sorting a series of data. In a spreadsheet I have in column A a series of numbers (like row names) and in column B the relative values, which may include zero values. In column D there is a list of "reference" values. What I need is to sort the values of columns A and B according to the differences between the values (Column B) and the reference ones (Column D), putting the zero value rows where there are "gaps". I don't know if I explain the problem clearly, so I include a file with an example. What I need is to get the result shown in columns F and G, regarding the sorting of rows. Any help would be much appreciated.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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