anthonychilaka
New member
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.
My appreciation to exceldemy for directing me here from the Excel tracker youtube video.
I attempted to follow this video
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.