![]() |
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? |
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? |
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