[Solved] Excel tracker (Problem with formula)

[anthonychilaka]

Good day all, and glad to be here.
My appreciation to exceldemy for directing me here from the Excel tracker youtube video.
I attempted to follow this video

My Challenge
Pending tab I input the excel formula

=FILTER(Task(TaskList!B:B<>0)*(TaskList!G:G="Not Done"))

to return the Boolean string in pending task but but I get #VALUE!

See attached file.
What I did to correct this
1. I had created 4 different array ranges (named Tasks, TaskArea, Task, Entry) in TaskList tab after the first range B1:B28,G1:G28 named Tasks did not work.
2. I changed the data type to number in B tab TaskList

Would appreciate a solution and tip on what I did wrong.
Thanks alot for your time.

 

[anthonychilaka]

I hope someone could help out with this.

 

[Aniruddah Alam]

Good day all, and glad to be here.
My appreciation to exceldemy for directing me here from the Excel tracker youtube video.
I attempted to follow this video

My Challenge
Pending tab I input the excel formula

=FILTER(Task(TaskList!B:B<>0)*(TaskList!G:G="Not Done"))

to return the Boolean string in pending task but but I get #VALUE!

See attached file.
What I did to correct this
1. I had created 4 different array ranges (named Tasks, TaskArea, Task, Entry) in TaskList tab after the first range B1:B28,G1:G28 named Tasks did not work.
2. I changed the data type to number in B tab TaskList

Would appreciate a solution and tip on what I did wrong.
Thanks alot for your time.

Dear Anthony,

I apologize for the delay in replying. I have reviewed your file and identified the issue. The problem is with the naming of the range. To ensure that the FILTER function provides accurate results, you need to select the entire B:G range for the named range, Task. This is because the return array from the formula (TaskList!B:B<>0)*(TaskList!G:G="Not Done") must be the same size as the named range, Task.

Here, I have modified the range of the named range Task like this:

As you can see, now it yields the desired result.

Let me know if you have any further questions or concerns.

Best regards

 

[anthonychilaka]

Dear Anthony,

I apologize for the delay in replying. I have reviewed your file and identified the issue. The problem is with the naming of the range. To ensure that the FILTER function provides accurate results, you need to select the entire B:G range for the named range, Task. This is because the return array from the formula (TaskList!B:B<>0)*(TaskList!G:G="Not Done") must be the same size as the named range, Task.

Here, I have modified the range of the named range Task like this:

As you can see, now it yields the desired result.

Let me know if you have any further questions or concerns.

Best regards

Thanks alot Aniruddah, this means alot. I will try this out and get back to soon.

 

[anthonychilaka]

Thanks so much. Issues solved.

 

[Aniruddah Alam]

Thanks so much. Issues solved.

Dear Anthony,
You are most welcome