Hi Ruth:

If I understand you correctly, you can use the following computed criterion
....

=Total=0

Now before you do AdvancedFilter ... you would want to have all the cells in
column A populated with the ProjectLeaders names for the output to be
meaningful. You can do this easily by selecting column A, then selecting all
the blank cells and copying the cell above and Pasting it with CTRL+ENTER.

"RWilliams" wrote:

Help please €¦

Scenario - I have a number of workbooks that have links to a €˜master to
manage days spent on about 20 projects. To make entering of relevant data
easier for the €˜Team leaders I would like to display only the projects that
relate to the team members even if they have not yet allotted time to it €“ ie
from below this would be P1 & P2 .

The table below is a very simplified version of the data, there are a number
of links both to and from the €˜master and a number of filters already
applied €¦ I think I can do this with a formula in an €˜Advanced Filter but
cannot work out how to display the rows that contain no data for some of the
team members €“ I have also tried with €˜If statements and €˜lookup but I
think I am making it more complicated than it is €¦ any thoughts would be
gratefully received €¦

Name Project Week 12 Week 13 Total
Mr A P1 3 3 6
P2 2 2 4
P3 0
Ms B P1 2 2 4
P2 0
P3 0
Mr C P1 0
P2 3 3 6
P3 0

Thanks in advance €¦
--
Thanks and have a good day

Ruth