Extracting a list of unique value from reference sheet based on some conditions
I have been trying to extract unique values from a different sheet. Suppose there is a sheet with Project Name, Project Owner and Project Type. I want to extract a list of Unique Project Owners from the other sheet who manages same Project Type. Here is an example data:
I am expecting these two results after applying the formula for both categories:
I have tried Distinct with Collect. This seems fine if I need to count these value but not when I need the list. Can anyone please help me with your expertise.
Help Article Resources
Check out the Formula Handbook template!