Please see attached sample.
In column L, I have an array that is counting the distinct numbers in column C for for the specific Month and Year in Column A. For some reason, for the months that don't start in row A2, in this case March and April, the count are off by 1. In summary, Feb 2015 count is spot on, but then March and April are both 1 too many.
Any ideas on what may be causing this?
Thanks in advance for your time.
Bookmarks