Sort column by text content

MsCynic

Board Regular
Joined
May 21, 2006
Messages
122
Hi guys, how would I sort a spreadsheet to put at the top all cells in a certain column that do not contain the word "sep"?

What I'm trying to do is isolate clients so I can see quickly at a glance who didn't have a sales call in September.

Currently each client has a cell in which I enter the month my team most recently called on them. Feel free to suggest a better way to track though - I'm totally open to suggestions that will keep me sane until the bosses purchase a CRM package ...

As usual, thanks in advance,
Jo
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

xapie128

Board Regular
Joined
Aug 26, 2006
Messages
82
This is a simple way that I'd do it, some of the gurus on this site might have a better idea...

I'd put =IF(A1="sep","x","a") in some unused column (say column AA). Then select all columns and sort by column AA first, and select "Then by" column A (assuming your data is in A, otherwise change the A1 in the IF formula and the column A to wherever your data with the "sep"s are).
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hi,

xapie128 provided you a sort as required, but perhaps your need can be solved using autofilter (see menu data/filter)
clicking on the black triangle of your filter
you get some options: select custom
how you can choose
"is not equal to"
or
"does not contain" (if "sep" would be part of the cell)

kind regards,
Erik
 

Forum statistics

Threads
1,175,931
Messages
5,900,381
Members
434,829
Latest member
Azuki96

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top