sort data by criteria other than ascending or decending

[HV man]

How do I sort data by criteria that is not ascending or decending -- such as
greater than number in a particular cell.

[Ken Wright]

Add a helper column with an IF statement for example, such
=IF(A1>100,"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" <HVman@discussions.microsoft.com> wrote in message
news:1FE7D07F-2D2D-4931-876F-D4F1A221D3A3@microsoft.com...
> How do I sort data by criteria that is not ascending or decending -- such
> as
> greater than number in a particular cell.