Posted to microsoft.public.excel.misc

external usenet poster

Posts: 2

Filtering question

I want to filter on only a small part of the text in a column. As an example
I want to filter on €œCT€. When I use an auto filter and do contains €œCT€, I
get unwanted items. I want CTL BR CARROT CT F but I dont want CTL BR CARROT
WH F or CTL BR CARROT CHIP F. I need to be able to put spaces before and
after the €œCT€. Does anyone have any ideas?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
filtering question	dwake	Excel Discussion (Misc queries)	2	September 6th 08 02:39 AM
Data filtering(?) Question	BryGuy77	Excel Discussion (Misc queries)	2	May 27th 08 09:59 AM
Filtering question	EllenM	Excel Discussion (Misc queries)	2	April 10th 07 01:22 PM
Excel Filtering Question	TA	Excel Discussion (Misc queries)	3	August 18th 06 05:19 AM
Filtering Question	allanbugg	Excel Discussion (Misc queries)	2	June 28th 06 01:23 PM

All times are GMT +1. The time now is 04:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us