Forum Discussion
Mc23
Jul 19, 2025Copper Contributor
Excel Task list
Hi All, I am having an issue finding a way to organize my task list. I have a task list with multiple tasks that is color coded by task codes. For example if on position A1 I introduce the task cod...
Harun24HR
Jul 22, 2025Bronze Contributor
Seems you need FILTER() function. See the attached file.
=FILTER(B4:B20,C4:C20="C")
=FILTER(B4:B20,C4:C20="D")
=FILTER(B4:B20,C4:C20="E")