View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Rogers[_2_] Mike Rogers[_2_] is offline
external usenet poster
 
Posts: 284
Default 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