Sorting..

  • Thread starter Thread starter shawn
  • Start date Start date
S

shawn

I have an Excel sheet that has about 1650 company names and addresses.

Some of my company names have ++ next to them and some have ** next to them.
The number of ++ and ** changes.

Any name with a + represents accounts we don't want to mail catalogs to. Any
name with a * represents accounts that have been blocked and we should also
not mail catalogs to. (I wouldn't have used * because it's a wildcard, but
they did this way before I started working here).

How do I sort my list so that every thing in column A (Name) that has a + or
* in it is grouped together? This way I can quickly highlight and either
copy them to another sheet or delete them.
 
How about just apply Data|Filter|Autofilter to that field?

Then you can filter to show the cells that contain + or ~* (the leading tilde is
important to treat the asterisk as an asterisk--not a wildcard character).

(You could use "begins with" in your filter, too.)
 
Thanks for the help.

I also figured out using ASAP Utilities I can do it. ASAP Utilities has so
many functions it's hard to find something sometimes.

If anyone wants to know, I highlighted what I wanted to sort, I went into
ASAP UTILITIES -> SELECT -> CONDITIONAL CELL SELECT. In there I can set
option for "Select all cells with a value like (text)" and have it look for
*++* and have it "Select: Entire Row".
 
Back
Top