Hi. I have two columns SME #1 (Name) and SME #2 (Name) with names of subject-matter experts from rows 5 to 155. In many cases, one SME is assigned to more than one course (one course=1 row).
I'd like to count the number of unique names in both columns.
SME #1 (Name) | SME #2 (Name)
Course 1 | Donald Duck |
Course 2 | Mickey Mouse | Fit-it Felix
Course 3 | Donald Duck | Mickey Mouse
There is only one SME for Course 1, while there are two for Course 2. There are two for Course 3, but both were already counted in Course 1 and 2.
The cell with the COUNT formula should display 3, since there are three unique names in both columns (Donald Duck, Michey Mouse, and Fix-it Felix). It should not count BLANK cells.
What is a good way to do this?