I need to count the number of times a name appears but if it appears twice for the same date, it ONLY counts as 1.
I have tried a mixture of COUNTIF, SUMIF, SUMPRODUCT formulas, and I can't seem to get it to do what I need. Please help!
I have attached a spreadsheet as reference with additional information on what I need as well.
Bookmarks