| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort Rows by Value in a Column
Hi,
I have a spreadsheet with a column of boolean data (either TRUE or FALSE). I'll need to sort the rows by this boolean value (so that I can delete a chunk of rows whose value in this column is FALSE and keep those rows those value in this column is TRUE). Howver, when I double-click on the header of this boolean column, nothing happened (they rows are not sorted). Any advice on how to sort? -Emily |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sort Rows by Value in a Column
Is this column in a List in xl2003? If not, double clicking on a column
header doesn't sort that I am aware of. -- Regards, Tom Ogilvy "Emily" wrote: Hi, I have a spreadsheet with a column of boolean data (either TRUE or FALSE). I'll need to sort the rows by this boolean value (so that I can delete a chunk of rows whose value in this column is FALSE and keep those rows those value in this column is TRUE). Howver, when I double-click on the header of this boolean column, nothing happened (they rows are not sorted). Any advice on how to sort? -Emily |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sort Rows by Value in a Column
Hi Tom,
What do you mean by "this column in a List in xl2003"? -Emily |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sort Rows by Value in a Column
Since you don't know, you have to select the data and do Data=Sort and
select the column you want to sort on. -- Regards, Tom Ogilvy "Emily" wrote in message ups.com... Hi Tom, What do you mean by "this column in a List in xl2003"? -Emily |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort data in rows to column | Excel Discussion (Misc queries) | |||
| How can I keep 2 rows of column headings out of sort data? | Excel Discussion (Misc queries) | |||
| How do I make a column of data sort into rows? | Excel Worksheet Functions | |||
| Group & sort rows that have a specific value in column C | Excel Worksheet Functions | |||
| Sort one column and entire rows get sorted | Excel Programming | |||
![Emily[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
