Complicated filter question

[ineveruseexcel]

Hi there,

I know absolutely nothing about excel and I have quite a difficult – for me at least – thing I want to do.
I have a file in which every row has 40 columns, and in some rows all the columns are filled in, in some only one, some multiple, you get it. What I want to do is filter the file in a way that only the rows in which there are filled in cells after empty cells remain. I'm not sure if that's a good explanation so I'll try to clarify it with a more visual approach:
This is what my file looks like:

a b c d e f g h i j k l m n o p q r s
1 x x x x x x x x x x
2 x x x x x x x x x x x x x x x
3 x x x x x x x x x x x x x x x x x x
4 x x x x x x x
5 x x x x x x x x x x x x x x x x x x
6 x x x x x x x x x x x x x
7 x x x x x x x x x x x

And I want to filter it so that I only keep rows 4 and 6. So only the rows where this happens: there is one or there are more empty cells, followed by filled in cells. Also, I only want this filter to apply just to columns f to s, if there is an empty cell somewhere in column a to e that should not be of influence on the filter.
O, and I am working with the newest excel (2011) on a mac.

Thanks in advance!


Wouter

 

[ineveruseexcel]

Thank you so much! It works great.