Hey! My boss is running some data analysis and asked if I could help pull the number of unique names per project ID number. I currently have a simple countif function that gives me the number of times a project ID appears in the sheet =countif(A:A,A728). This results in 18 people showing on this project. The problem is sometimes the same person could be entered into the project more than once. I can easily figure out how many times that person appears by using =countifs(A:A,A728,I:I,I728,J:J,J728) (searching project ID, FirstName, LastName). This results in 3 (Juan is entered on this form three).
In the scenario given above, there are actually 6 people entered on this project, each one is entered into this project ID thrice. How would I write a formula that would result in the number of unique names assigned to a given project ID (in this case 6)?
In the scenario given above, there are actually 6 people entered on this project, each one is entered into this project ID thrice. How would I write a formula that would result in the number of unique names assigned to a given project ID (in this case 6)?