I put together a monthly report that includes a column with unique names. I use a formula to count the number of unique names listed each month (For example, if there were three entries for Smith, Sarah and two for Jones, Martha, the formula would give me 2
as a result). The formula I use is =SUMPRODUCT((B5:B46<>"")/COUNTIF(B5:B46,B5:B46&""))
and it works beautifully. The list is, and has to remain, sorted by date, not name.
With the end of the year approaching, I'd like to put together an annual summary, including a count of how many unique names appeared throughout the year. I have this set up as a workbook, with separate sheets for each month. What I am looking for is a method for counting unique names that appear across these twelve sheets (so that, if there was one entry each for Smith, Sarah and Jones, Martha in January, and two for Smith, Sarah and one for Jones, Martha in February, I would still get 2
as my result).
I've researched, but all I'm finding are ways to count how many times a specific name appears, not how many unique names there are. I've done a little experimenting, to see if I could figure it out, but I am clearly out of my league. Willing to use and try anything, but I can't install any programs or add-ons without a ridiculous process to get approval, which generally takes months, so I would like to avoid that.