Displaying first entry and hiding duplicate names on project plan sheet
@Paul Newcome You have been extremely helpful to others in the forum, so I am hoping to reach out and work with you.
My objective is to have team member names displayed in a rollup/dashboard without excessive manual data entry by project leaders. My thought is that on the project plan sheet, the project leader must assign tasks to team members. I would like to use this column, named "Assigned To", which has contact list properties so automated workflows send notifications, to create a report sheet of just the names, which I could then use the report to display on the dashboard.
I am unable to figure out how to display just the first instance of a name either in a helper column or on another sheet/report since a team member may have many tasks assigned to them. I have tried the following:
Row 1 is additional header info that is referencing main metadata page.
Row 2 : =COUNT(DISTINCT(Assigned To$2:Assigned To@row))
Row 3 and beyond: =IF(COUNT(DISTINCT(Assigned To$2:Assigned To@row)) <> COUNT(DISTINCT(Assigned To$2:Assigned To2)), COUNT(DISTINCT(Assigned To$2:Assigned To@row)))
I receive unparseable in return
=IFERROR(IF(LEN([Assigned To]1) = 0, "", IF(COUNTIFS([Assigned To]:[Assigned To], [Assigned To]1) = 1, 0, 1)), 0)
This solution returns the duplicates as 1 and non-duplicates as 0, but I don't know how to then combine them to get just the first instance on a list.
There is proprietary information on the template sheet as I test am not sure how to share the sheet without exposing the information if needed as a reference.
Thank you so much in advance!
Help Article Resources
Check out the Formula Handbook template!