Thread: Filtering Data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JulieD JulieD is offline
external usenet poster
 
Posts: 618
Default Filtering Data

Hi Michael

sorry, not really sure what you're after, but check out
www.contextures.com/tiptech.html for lots of good info on filtering (and
other things), if you can't find your answer there, please post back and
type out a small sample of your existing data and what you want to be able
to achieve usingthe filter.
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Michael" wrote in message
om...
I would like to filter (not autofilter, the other one, is "Special
Filter" the exact name in english?) data in my excel Sheet, but it
just does not work...

Here my Problem:
I have a list with several columns, most of them include text. Then I
want filtering data, so that it only shows me the rows with the
following condition in a specific field:
[Content] < ''
[Content] < 'xyz'
-- the field must not be empty and must not contain the word 'xyz'...

How can I realize that?

A second problem is, that the output is static, means that it doesn't
change when the source changes. I think, I can solve this with vba.
Can somebody say the corresponding function?

Dou you know a good website or document with such information, i
rarely found some good stuff for vba/excel.

Ok... many questions, I know... Thanks for your trouble in advance.

Michael