sort data by criteria other than ascending or decending

H

HV man

How do I sort data by criteria that is not ascending or decending -- such as
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 :)
------------------------------­------------------------------­----------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting Spreadsheet Help 4
Dealing with the error: unable to filter on excel hc home school 0
Sorting Multiple Tables 1
VBA Macro help 1
REMOVE SORT WARNING 2
How to bulk add section breaks after a particular combination of letters/numbers 0
Countif Function Help 1
Outlook Web - Sorting Calendars by Alphabetical order? 0

Top