L
Lynda
How do I figure the percentage between two columns and then sort the columns
by the highest percentage first?
by the highest percentage first?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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.
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.
G
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
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
G
Gord Dibben
Make that "descending"
Gord
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