ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how do you sort two columns; data and headers (https://www.excelbanter.com/excel-programming/348457-how-do-you-sort-two-columns%3B-data-headers.html)

Bolek

how do you sort two columns; data and headers
 
I have a data table with two columns. In column A I have headers that are
relatred to the number in column B. I want to sort the numbers column ,high
to low, and I want to keep the header relationship with these numbers and
then plot the results as a bar graph.

I did this suiccessfully once, I think I used the control key to pick the
columns. Now I cant duplicate what I did If what I did was even correct.
Bill

Ian

how do you sort two columns; data and headers
 
To sort data, select all the data, then go to DataSort, then sort ascending
by column B.

--
Ian
--
"Bolek" wrote in message
...
I have a data table with two columns. In column A I have headers that are
relatred to the number in column B. I want to sort the numbers column
,high
to low, and I want to keep the header relationship with these numbers and
then plot the results as a bar graph.

I did this suiccessfully once, I think I used the control key to pick the
columns. Now I cant duplicate what I did If what I did was even correct.
Bill





All times are GMT +1. The time now is 07:26 AM.

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