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.
Bookmarks