Running Excel 2003 on XP.
What would be the macro to *only* count the number of *consecutive*
rows from the max date backward (don't count any other rows) and get
the earliest date of that series in the final result? Here's a sample.
Thanks in advance for any tips/direction on this!
Input
ID Event Event Date
1 Create 4/21/06 (count)
1 Create 4/20/06 (count)
1 Create 4/19/06 (count)
2 Complete 4/21/06 (count)
2 Complete 4/20/06 (count)
2 Complete 4/19/06 (count)
2 Complete 7/05/05 (don't count)
2 Complete 7/04/05 (don't count)
2 Complete 7/03/05 (don't count)
3 Update 4/21/06 (count)
3 Update 9/13/05 (don't count)
3 Update 8/25/04 (don't count)

Desired Output
ID Event Since Date Count
1 Create 4/19/06 3
2 Complete 4/19/06 3
3 Update 4/21/06 1