Hi,

I have downloaded a set of data showing the number of hits on my website
which has data by day. I want to create a subset of this data which excludes
the weekend, while at the same time retaining the original data.

My data is in the following format:
Day ; Date ; Number of hits (where ; represents a new column)

So the data I paste on Worksheet 1
Friday ; 1/1/2009 ; 25
Saturday ' 2/1/2009 ; 5
Sunday ' 3/1/2009 ; 4
Monday ; 4/1/2009 ; 50

Would appear on worksheet 2 as
Friday ; 1/1/2009 ; 25
Monday ; 4/1/2009 ; 50

I know I could copy the data, filter it and remove the rows with Saturday
and Sunday in but I would quite like to just paste my data in the original
worksheet and see the updates appear on another worksheet

Any ideas? I think a combination of AND and MIN should do it but cant quite
solve it