ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sorting by numerical value so that subjects follow (https://www.excelbanter.com/excel-discussion-misc-queries/199528-sorting-numerical-value-so-subjects-follow.html)

al

Sorting by numerical value so that subjects follow
 
Hi

I would like to sort a list of company's by their profit margins. Column A
contains the company name and B, the profit margin. When I sort the profit
margins, the company titles do not rearrange with the sorted column B.

Thanks in advance.
--
al

Mike Rogers[_2_]

Sorting by numerical value so that subjects follow
 
al

When you sort you need to select all the data (in your case, Column A &
Column B) then sort by column B

Mike Rogers

"al" wrote:

Hi

I would like to sort a list of company's by their profit margins. Column A
contains the company name and B, the profit margin. When I sort the profit
margins, the company titles do not rearrange with the sorted column B.

Thanks in advance.
--
al



All times are GMT +1. The time now is 04:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com