| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for Excel Worksheet
How do I figure the percentage between two columns and then sort the columns
by the highest percentage first? -- Lynda |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Then Else Formula for Excel Worksheet | Excel Worksheet Functions | |||
| Writing formula for excel worksheet | New Users to Excel | |||
| How do I lock a formula in a cell in an Excel worksheet? | Excel Worksheet Functions | |||
| How do I make formula in Excel from other worksheet? | Excel Worksheet Functions | |||
| Display excel formula on worksheet | Excel Worksheet Functions | |||
Linear Mode
