Trying to create a simple report that will list all project managers from (3) sheets without duplicates. I can get the report to give me all the project manager names without any issues. The problem I have is it showed duplicate rows of the same project manager. I would be ok with a single project manager name entry with their project count like this:
John Doe (10)
Mary Smith (5)
Any suggestions?