Hi!
I need help in counting the number of consecutive days of employment for the
same person. (excel funcion or VBA)
F.ex.
A B C D E F
1 John 08-12-2009 John 6 days ended on 13-12-2009
2 John 09-12-2009 4 days enden on 19-12-2009
3 John 10-12-2009 Anders 1
4 John 11-12-2009 8
5 John 12-12-2009 1
6 John 13-12-2009 and so on
7 John 16-12-2009
8 John 17-12-2009
9 John 18-12-2009
10 John 19-12-2009
11 Anders 07-12-2009
12 Anders 09-12-2009
14 Anders 10-12-2009
15 Anders 11-12-2009
16 Anders 12-12-2009
17 Anders 13-12-2009
18 Anders 14-12-2009
19 Anders 15-12-2009
20 Anders 16-12-2009
21 Anders 19-12-2009

I use Excel 2007 and have around 70.000 rows. There are no blanks
I have tried countif, If/then but can't seem to find the solution. Any help
would be greatly appreciated.

-------
LEG-denmark