ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sorting Columns (https://www.excelbanter.com/excel-discussion-misc-queries/228097-sorting-columns.html)

perry

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?

Mike H

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?


perry

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?



All times are GMT +1. The time now is 02:41 PM.

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