Formula to lookup multiple names with a criteria

Hi,

I hope someone here can help me. I am struggling with finding a right formula to lookup the data i need.

Attached the example spreadsheet.

Basically i need a lookup formula

so on 26/07/2021 - a formula to bring up all the names that has number greater than 0 on the 26/07/2021 and also a split by department.

Appreciated if anyone can help.

Thanks
Sansan