L Lynda May 14, 2008 #1 How do I figure the percentage between two columns and then sort the columns by the highest percentage first?
How do I figure the percentage between two columns and then sort the columns by the highest percentage first?
J JE McGimpsey May 14, 2008 #2 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.
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.
G Gord Dibben May 14, 2008 #3 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
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
G Gord Dibben May 15, 2008 #4 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 Click to expand...
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 Click to expand...
