Dear All,

I have a 20 name (list table) and some of them is hit their target and some is not (pending).

How to create another table to list out (Automatic with formula) all the pending list?

Please check attachment for more information.

Thank you for help.

Help.xlsx