« Flyer's rights web site: nothing current but things in the works | Main | Using regular expressions in OpenOffice Calc filters -- phrases like "contains" rather than equals, less than, etc. »

November 19, 2007

TrackBack

TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a00d8341cdb1753ef00e54f8aac518834

Listed below are links to weblogs that reference Using the Advanced Filter:

Comments

In case I do not require all the fields, how do I get only the required fields?
This is possible in Excel. Can some one help?

Hi TT Raja,

In that case you'd want to use the Data Pilot which lets you both filter and restrict the fields.

OK, I misstype my name once and it keeps saving the misspelling. Just redoing it. ;>

In case I do not require all the fields, how do I get only the required fields? This is possible in Excel. Can some one help?

Great tutorial.

It must be advertised that the 'Advanced' Filter cannot handle more than 8 criteria.

I have a file with about 500 records and I need to filter for about 25 of them using just one field. Everything works fine up to 8 criteria. Then Calc claims there is an error in the criteria!

What it should say is "I cannot count beyond 8".

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment

Comments are moderated, and will not appear until the author has approved them.

GetOpenOffice Consulting

Get Book Resources

Search This Blog