G
Guest
How do I sort data by criteria that is not ascending or decending -- such as
greater than number in a particular cell.
greater than number in a particular cell.
K
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
----------------------------------------------------------------------------
=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
----------------------------------------------------------------------------