Need help with the formula

Hanuman Veda

Hi All,

Am sharing the source file in excel format. We have overall 225 projects out of which I need only those projects names to be populated which meets the criteria.

Report (Expected) View.xlsx

1.     We have 14 categories, under Primary Business Product Portfolio and 58 Execution projects under Project Phase Column in source file.

2.     Only these 58 projects names should be populated under Project Phase Execution column from Source file in Report View. And if I select Clinical System Operations from dropdown it should populate only those project names which are associated with Clinical System Operations in the next column (Project Phase Execution) out of 58 Projects and similarly, if I select other Primary Business Product Portfolio from dropdown it should show the projects associated with that category.

Please anyone help me with the formula.

Thank you,

Hanuman Veda

Source File.xlsx

Paul Newcome

Have you looked into creating a row report?