Sorry, English isnt my mother tongue, hope youll be able to understand my
question anyway.
I have a sheet with four columns of data. Three of them contain numbers and
the last one contains a word like the example bellow.

In Out Pending Name
1 3 2 Andrew
5 3 7 Mike
3 2 4 Andrew
2 7 1 Mary
4 5 1 Andrew

Now, if I want to quickly find all rows containing the word €œAndrew€� I go to
Edit, click Find and click replace and type Andrew into the €œFind what€� space
and Andrew into the €œreplace with€� space. After that I format the fonts to
desired color and press ok and then click €œreplace all€� and all Andrews get
colored or whatever I chose to format.
How do I go from here if I want to have only the €œAndrew€� rows? Is there any
why to do that?

Thank you very much for helping me. I appreciate it a lot!

M. Larsen

Hi M,

Look at the auto filter feature.

See Debra Dalgleish's tutorial at:

http://www.contextures.com/xlautofilter01.html

You might also wish to look at Ron de Bruin's EasyFilter addin which can be
freely downloaded at:

http://www.rondebruin.nl/easyfilter.htm

---
Regards,
Norman



"Cyprus" wrote in message
...
Sorry, English isn't my mother tongue, hope you'll be able to understand
my
question anyway.
I have a sheet with four columns of data. Three of them contain numbers
and
the last one contains a word like the example bellow.

In Out Pending Name
1 3 2 Andrew
5 3 7 Mike
3 2 4 Andrew
2 7 1 Mary
4 5 1 Andrew

Now, if I want to quickly find all rows containing the word "Andrew" I go
to
Edit, click Find and click replace and type Andrew into the "Find what"
space
and Andrew into the "replace with" space. After that I format the fonts to
desired color and press ok and then click "replace all" and all Andrews
get
colored or whatever I chose to format.
How do I go from here if I want to have only the "Andrew" rows? Is there
any
why to do that?

Thank you very much for helping me. I appreciate it a lot!

M. Larsen

THANK YOU VERY MUCH!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Ron de Bruin's EasyFilter is KING!!

You cannot imagine how many hours of work you saved me and WILL save me.
Thank soooo much!!

M. Larsen


"Norman Jones" wrote:

Hi M,

Look at the auto filter feature.

See Debra Dalgleish's tutorial at:

http://www.contextures.com/xlautofilter01.html

You might also wish to look at Ron de Bruin's EasyFilter addin which can be
freely downloaded at:

http://www.rondebruin.nl/easyfilter.htm

---
Regards,
Norman



"Cyprus" wrote in message
...
Sorry, English isn't my mother tongue, hope you'll be able to understand
my
question anyway.
I have a sheet with four columns of data. Three of them contain numbers
and
the last one contains a word like the example bellow.

In Out Pending Name
1 3 2 Andrew
5 3 7 Mike
3 2 4 Andrew
2 7 1 Mary
4 5 1 Andrew

Now, if I want to quickly find all rows containing the word "Andrew" I go
to
Edit, click Find and click replace and type Andrew into the "Find what"
space
and Andrew into the "replace with" space. After that I format the fonts to
desired color and press ok and then click "replace all" and all Andrews
get
colored or whatever I chose to format.
How do I go from here if I want to have only the "Andrew" rows? Is there
any
why to do that?

Thank you very much for helping me. I appreciate it a lot!

M. Larsen

Glad you like it


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Cyprus" wrote in message ...
THANK YOU VERY MUCH!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Ron de Bruin's EasyFilter is KING!!

You cannot imagine how many hours of work you saved me and WILL save me.
Thank soooo much!!

M. Larsen


"Norman Jones" wrote:

Hi M,

Look at the auto filter feature.

See Debra Dalgleish's tutorial at:

http://www.contextures.com/xlautofilter01.html

You might also wish to look at Ron de Bruin's EasyFilter addin which can be
freely downloaded at:

http://www.rondebruin.nl/easyfilter.htm

---
Regards,
Norman



"Cyprus" wrote in message
...
Sorry, English isn't my mother tongue, hope you'll be able to understand
my
question anyway.
I have a sheet with four columns of data. Three of them contain numbers
and
the last one contains a word like the example bellow.

In Out Pending Name
1 3 2 Andrew
5 3 7 Mike
3 2 4 Andrew
2 7 1 Mary
4 5 1 Andrew

Now, if I want to quickly find all rows containing the word "Andrew" I go
to
Edit, click Find and click replace and type Andrew into the "Find what"
space
and Andrew into the "replace with" space. After that I format the fonts to
desired color and press ok and then click "replace all" and all Andrews
get
colored or whatever I chose to format.
How do I go from here if I want to have only the "Andrew" rows? Is there
any
why to do that?

Thank you very much for helping me. I appreciate it a lot!

M. Larsen