One way:


With values in columns A and B, and calculating the percentage
difference between the two columns (with column A as the base):

C1: =B1/A1 - 1

Format C1 as a percentage.

Copy down as far as required.

With a cell in column C selected, choose Data/Sort..., sorting on Column
C while selecting the "Descending" radio button.



In article ,
Lynda wrote:

How do I figure the percentage between two columns and then sort the columns
by the highest percentage first?