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