Re: Extracting an exact phrase from a Cell
- From: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
- Date: Thu, 01 Sep 2005 14:23:30 -0500
Select your range (all the range--not just a column or two).
Then apply
Data|filter|autofilter
You'll see that the top row in each column in that selection has a dropdown
arrow in it.
You can use that dropdown to show just the stuff you want to see.
There's an option in that dropdown list called "custom".
Choose that
scroll down the list until you see Contains
type in Monitor
click ok
And tada, you only see the rows that have Monitor in that column.
If you wanted, you could select those visible rows and copy them. Then paste
them into a new worksheet.
Debra Dalgleish has some nice instructions at:
http://contextures.com/xlautofilter01.html
mazalam wrote:
>
> ilanr01 Wrote:
> > Use Data\autofilter onyour range and filter using Custom\contains
> > MONITOR
> > Ilan
>
> What version of Excel does that? I can only see "Data" then "Filter"
> and then two options:
> Auto Filter
> Advanced Filter
>
> --
> mazalam
> ------------------------------------------------------------------------
> mazalam's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26768
> View this thread: http://www.excelforum.com/showthread.php?threadid=401184
--
Dave Peterson
.
- References:
- Extracting an exact phrase from a Cell
- From: mazalam
- Re: Extracting an exact phrase from a Cell
- From: ilanr01
- Re: Extracting an exact phrase from a Cell
- From: mazalam
- Extracting an exact phrase from a Cell
- Prev by Date: Re: Highlight Cell when value reaches every interval of 500
- Next by Date: Re: Moving cells to another workbook sequentially
- Previous by thread: Re: Extracting an exact phrase from a Cell
- Next by thread: How can I calculate overtime?
- Index(es):
Relevant Pages
|
