Excel Guri
Good people,
I am trying to set up a Excel macro that will look at a time value
that has to run in a sequence of three.
If there is only one occasion on the particular day the entire row is
to be deleted row. A small example follows.
Can you assist with the code please.



A B C D E F G H
DELETE 1 20/3/05 1 4:37 MELBOURNE 2 12 3
DELETE 2 20/3/05 1 4:15 BALLINA 6 2 3
DELETE 3 20/3/05 1 4:15 BALLINA 6 6 5
RETAIN 4 19/3/05 7 4:37 TOOWOOMBA 2 5 4
RETAIN 5 19/3/05 7 4:37 TOOWOOMBA 2 8 8
RETAIN 6 19/3/05 7 4:37 TOOWOOMBA 2 9 0
DELETE 7 19/3/05 7 5:15 TOOWOOMBA 3 2 2
DELETE 8 19/3/05 7 5:15 TOOWOOMBA 3 3 2
DELETE 9 19/3/05 7 1:15 BRISBANE 2 3 2
DELETE 10 19/3/05 7 1:15 BRISBANE 2 8 3
RETAIN 11 19/3/05 7 1:05 GEELONG 2 2 2
RETAIN 12 19/3/05 7 1:05 GEELONG 2 3 8
RETAIN 13 19/3/05 7 1:05 GEELONG 2 5 0