I need help figuring out an easier way to do this. I need to count unique ideas per month, but with a caveat:
If there are 50 Unique IDs in January. I need to exclude any of those IDs that appear in February before I take a unique count of IDs in February. In march, I would have to exclude the unique IDs that appeared in both January and February.
Essentially:
If I, KP, appear in January, I should not be included in February. So if there was KP and DK in February the unique count of February would 1 not 2 because I was already counted in January.
HELP!!!!
