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