| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Two Headers, one subject column and various columns with data | Charts and Charting in Excel | |||
| How can I change the data in columns into headers? | Excel Worksheet Functions | |||
| ? Pivot Table from 3 columns of raw data with headers | Excel Discussion (Misc queries) | |||
| data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
| How to Sort Data by columns and display the data on GUI using Visual Basic | Excel Programming | |||
Linear Mode
