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
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

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
 

Watch MrExcel Video

Forum statistics

Threads
1,112,937
Messages
5,543,095
Members
410,583
Latest member
gazz57
Top