Formula for Excel Worksheet
 

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

Formula for Excel Worksheet
 

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?

Formula for Excel Worksheet
 

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 DataSort on Column C ascending.


Gord Dibben MS Excel MVP

On Wed, 14 May 2008 15:04:00 -0700, Lynda
wrote:

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

Formula for Excel Worksheet
 

Make that "descending"


Gord

On Wed, 14 May 2008 15:38:02 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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 DataSort on Column C ascending.


Gord Dibben MS Excel MVP

On Wed, 14 May 2008 15:04:00 -0700, Lynda
wrote:

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