Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Counting unique items based on date
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="DKS, post: 3715985"] First test with timestamp included in the date, and the date being one of the extremes being tested and the formula does not work. For example: in your test-data hereunder if I put only one record for dept A for date March 15; and if I test for Jan 1st till Marc 15th for dept A, I get one number less than the actual number. Just FYI. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Counting unique items based on date
Top