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

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

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,141,429
Messages
5,706,405
Members
421,447
Latest member
arthuro2021

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