It sounded like a pretty simple COUNTIF formula until you used that word "unique".
I know how to do that in VBA, but I would have to think about how to do it with a formula.
------------- Added Later -----------------
I went to Excel help and searched on COUNTIF unique. Excel help's suggest was to use a pivot table. I should have thought of that.
Bookmarks