| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sort data by criteria other than ascending or decending
How do I sort data by criteria that is not ascending or decending -- such as
greater than number in a particular cell. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sort data by criteria other than ascending or decending
Add a helper column with an IF statement for example, such
=IF(A1100,"TRUE","FALSE") You can then sort on this column, plus any others you have. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "HV man" wrote in message ... How do I sort data by criteria that is not ascending or decending -- such as greater than number in a particular cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using AutoFilter to Sort Data Pulled in by INDEX / MATCH | Excel Worksheet Functions | |||
| data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
| sorting more than 3 keys | Excel Discussion (Misc queries) | |||
| Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
| Data > Sort function amnesia? | Excel Discussion (Misc queries) | |||
Linear Mode
