LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Filtering Data

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 of data - autmatically based on data on other sheet uptonfamilywa Excel Discussion (Misc queries) 1 June 20th 09 12:46 AM
filtering row data Gary''s Student Excel Worksheet Functions 3 October 26th 05 07:03 PM
Filtering out Data Jo Davis Excel Discussion (Misc queries) 1 July 7th 05 11:34 AM
Data Filtering jnorton Excel Discussion (Misc queries) 2 December 22nd 04 05:53 PM
Help with Filtering data and matching two data sets? masai_chadi Excel Programming 2 March 1st 04 10:33 PM


All times are GMT +1. The time now is 06:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"