Formula for Excel Worksheet

[Lynda]

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

 

[JE McGimpsey]

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.

 

[Gord Dibben]

Assume the two columns of numbers are A and B

In C1 enter =A1/B1 and double-click to fill down.

Select all three columns and Data>Sort on Column C ascending.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Make that "descending"


Gord

Assume the two columns of numbers are A and B

In C1 enter =A1/B1 and double-click to fill down.

Select all three columns and Data>Sort on Column C ascending.


Gord Dibben MS Excel MVP