I have a problem where I need to count unique criteria. For example:
Name --Yellow---Blue---Green--
Bob ------y--------------------
Steve --------------------y----
Bob ----------------------y----
John -------------y------------
Bob ------y--------------------
James-----y-------------------
I need to count the yellows, blues and greens, but I can't count the duplicate names per color.
So Yellow would be 2, Green 2, and Blue 1.
If this could somehow be done in a pivot tables I would like to know, but I've tried some counting solutions for pivot tables and they haven't worked when I need to filter the names by color. (Yellow would be 1.5 in the formulas I use)
I'm not great with macros, but I'll figure it out if someone can provide a little help.
Bookmarks