New to the forum. I appreciate any help that can be provided.
I have a worksheet of about 4000 rows that include dates and department data.
Example:
Department Event Date
Department 1 1/1/2009
Department 3 3/1/2009
Department 4 2/1/2009
Department 1 4/1/2009
Department 1 5/1/2009
etc....
I would like to build a formula on another sheet that evaluates the list of dates for each department and produces the number of days representing the longest streak for that department. In the example above for Department 1, I want to see the number of days between 1/1/2009 and 4/1/2009. As a longer streak develops for that department, I would like to see that number of dates appear and begin to grow.
I've looked over the forum, and found no obvious candidates.
Any thoughts?
Bookmarks