Filter rows based upon unique value

john.radzikinas55991

I created a report that retrieves the Assigned To column field for all of the rows in a project sheet.  There are several rows where the same resource name is shown in several rows.  How do I filter all of those rows into a list that includes just the unique resource names for all the project rows?  Do I need to do some rollup into a higher sheet or report?  

Andrée Starå

Hi John,

Currently, you would need to collect/filter that information on the main sheet or linked to another sheet.

Can you tell me more details on what the process is so that I can maybe get some other ideas and give you some recommendations?

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting