I have a question/problem/need some help regarding some formula I am trying to use. The situation is the following: I have my Excel sheet as datasource 1, which is the main one, that has the following columns (that I am trying to use):
As can be seen, column A has "project type", column C the name, column D the task type (level 1), column E the task type level 2 and the last column (that does have data, but in other rows) is task level 3.
Then, on my second Excel file I have the 'master task data', where it shows all the project types that exist, along with the task it has and also a column that is called 'Dependientes_MT' which has the number of tasks it has in a level below them.
In the image, it can be seen it is columns A-B-C-D and E.
What I want to do is to filter the data in the first file by using the criteria of 'Dependientes_MT'=0 from the second file, meaning, I want to show only those that do not have 'child tasks' so to speak. So far I have tried: