Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting with Column
I have data in multiple columns. In all the column in Row 1, I have a number.
I want to sort the columns according to the numbers in the Row 1. Is there any way in Excel to do it. I am using Excel 2003. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting with Column
Last response didn't seem to post. If i understand your problem correctly
this will work. Hilight the data you want to sort the go to Data-Sort-sort-Options and check the sort left to right box. -- -John Please rate when your question is answered to help us and others know what is helpful. "mrbalaje" wrote: I have data in multiple columns. In all the column in Row 1, I have a number. I want to sort the columns according to the numbers in the Row 1. Is there any way in Excel to do it. I am using Excel 2003. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting with Column
Select all your data, including the first row.
<Data <Sort <Options Click on "Sort Left To Right". Then <OK Then pick sort on Row1, ascending or descending, then <OK. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "mrbalaje" wrote in message ... I have data in multiple columns. In all the column in Row 1, I have a number. I want to sort the columns according to the numbers in the Row 1. Is there any way in Excel to do it. I am using Excel 2003. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting with Column
Hi,
Filter by using advanced criteria The Advanced Filter command on the Data menu lets you use complex criteria (criteria: Conditions you specify to limit which records are included in the result set of a query. For example, the following criterion selects records for which the value for the Order Amount field is greater than 30,000: Order Amount 30000.) to filter a range, but it works differently from the AutoFilter command in several important ways. It displays the Advanced Filter dialog box instead of the Custom AutoFilter dialog box. You do not type the complex criteria in the Advanced Filter dialog box as you do in the Custom AutoFilter dialog box. Rather, you type the complex criteria in a criteria range on the worksheet and above the range you want to filter. Excel uses the separate criteria range in the Advanced Filter dialog box as the source for the complex criteria. Although you can filter a range in place, like the AutoFilter command, the Advanced Filter command does not display drop-down lists for the columns. 1. Insert at least three blank rows above the range that can be used as a criteria range. The criteria range must have column labels. Make sure there is at least one blank row between the criteria values and the range. 2. In the rows below the column labels, type the criteria you want to match. 3. Click a cell in the range. 4. On the Data menu, point to Filter, and then click Advanced Filter. 5. To filter the range by hiding rows that don't match your criteria, click Filter the list, in-place. To filter the range by copying rows that match your criteria to another area of the worksheet, click Copy to another location, click in the Copy to box, and then click the upper-left corner of the area where you want to paste the rows. 6. In the Criteria range box, enter the reference for the criteria range, including the criteria labels. To move the Advanced Filter dialog box out of the way temporarily while you select the criteria range, click Collapse Dialog . 7. To change how the data is filtered, change the values in the criteria range and filter the data again. Notes You can name a range Criteria, and the reference for the range will appear automatically in the Criteria range box. You can also define the name Database for the range of data to be filtered and define the name Extract for the area where you want to paste the rows, and these ranges will appear automatically in the List range and Copy to boxes, respectively. When you copy filtered rows to another location, you can specify which columns to include in the copy. Before filtering, copy the column labels for the columns you want to the first row of the area where you plan to paste the filtered rows. When you filter, enter a reference to the copied column labels in the Copy to box. The copied rows will then include only the columns for which you copied the labels. Challa Prabhu "mrbalaje" wrote: I have data in multiple columns. In all the column in Row 1, I have a number. I want to sort the columns according to the numbers in the Row 1. Is there any way in Excel to do it. I am using Excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column sorting | Excel Discussion (Misc queries) | |||
sorting by one column | Excel Discussion (Misc queries) | |||
How do I limit sorting a column to the column? | Excel Worksheet Functions | |||
Sorting 1 column into two | Excel Discussion (Misc queries) | |||
Right column doesn't change when sorting left column. | Excel Discussion (Misc queries) |