Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pictures didn't follow the row move when sorting | Excel Discussion (Misc queries) | |||
Sorting Numbers with established numerical hiearchy | Excel Discussion (Misc queries) | |||
sorting numerical data | Excel Discussion (Misc queries) | |||
sorting data using numerical list | Excel Worksheet Functions | |||
Sorting Numerical Values... | Excel Worksheet Functions |