Hello Guys!

I have a worksheet containg 2 colums and couple of hundred
rows. For examle:

8:45 384
9:30 384
12:40 384
17:05 384
7:35 566
10:30 566
11:39 566
16:05 566
17.10 566

How can I leave only first and the last timestamp for number
384 and 566 and delete all the other rows. How could I do
this with macro?

The result should be:
8:45 384
17:05 384
7:35 566
17.10 566

Please help me,
Jessica

I have already got a solution

   Do Until ActiveCell.Value = ""
      If ActiveCell.Offset(1, 0).Value = ActiveCell.Value And ActiveCell.Offset(2, 0).Value = ActiveCell.Value Then
         ActiveCell.Offset(1, 0).EntireRow.Delete
      Else
         ActiveCell.Offset(1, 0).Activate
      End If
   Loop

Jessica