I'm trying to setup a similar type tool. I've got a database of call logs that I need to count based on the employee ID(primary key) then date and only within the last 12 weeks. Its currently setup to countifs the ID then the date within a defined range. I need it to still do this but count consecutive dates as 1 occurrence.
Any ideas would be helpful.
Use a column of formulas that flags any date/ID combo that occurs in the last day (or doesn't occur) and use that as a filter.
Bernie Deitrick
Excel MVP 2000-2010
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks