| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Columns
Column A contains names, column B contains the percent changes that have
taken place (calculated from data in another table). How can I sort (decending) the values in Column B and maintain its association with the name in column A? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting Columns
Hi,
Select both columns and then sort on Column A and the 2 columns will remain 'Paired' Mike "Perry" wrote: Column A contains names, column B contains the percent changes that have taken place (calculated from data in another table). How can I sort (decending) the values in Column B and maintain its association with the name in column A? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting Columns
I tried that and it didn't do anything. Note that column B does not contain
numbers. It contains equations ( =(D5-C5)/C5)) which give the percent change. "Mike H" wrote: Hi, Select both columns and then sort on Column A and the 2 columns will remain 'Paired' Mike "Perry" wrote: Column A contains names, column B contains the percent changes that have taken place (calculated from data in another table). How can I sort (decending) the values in Column B and maintain its association with the name in column A? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
| Sorting columns | Excel Worksheet Functions | |||
| Sorting two columns (again) | Excel Worksheet Functions | |||
| Sorting 2 columns | Excel Discussion (Misc queries) | |||
| Regarding Sorting Columns | Excel Discussion (Misc queries) | |||
Linear Mode
