I am looking for a formula to calculate one of three activity types once, if all three occur on the same date and time. Is this possible to do through an Excel formula? The values would likely be grouped together... either two of three, or all three. I have attached an example (rows 3-5).
Combinations can be:
ACTIVITY_CREATE_QUESTION
ACTIVITY_CREATE_MESSAGE
ACTIVITY_CREATE_THREAD
ACTIVITY_CREATE_QUESTION
ACTIVITY_CREATE_MESSAGE
ACTIVITY_CREATE_QUESTION
ACTIVITY_CREATE_THREAD
ACTIVITY_CREATE_MESSAGE
ACTIVITY_CREATE_THREAD
ACTIVITY_CREATE_MESSAGE
ACTIVITY_CREATE_QUESTION
ACTIVITY_CREATE_THREAD
ACTIVITY_CREATE_QUESTION
ACTIVITY_CREATE_THREAD
ACTIVITY_CREATE_MESSAGE
There may be up to 200,000 records, and not all activity types may exist but it is 95%+ likely all three will be used.
If one of the above combinations are used with the same date/time, I would just like to count that as one occurrence.
Bookmarks