View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
drurjen drurjen is offline
external usenet poster
 
Posts: 3
Default debug repeat entries with a random function and erase the rest

Good morning. I have a txt file with 4 comma delimited fields: Date,
ID, Time and I/O. The fields are generated by a biometric time
attendance system. The main problem I have is debugging repeat entries.
For example,

If an employee punches in twice, I'd have the following:

11/27/2006 16 16:31:27 2
11/27/2006 16 16:32:21 2

What I want is to select a random entry of these within a 5 minute
interval and erase the rest. Any ideas on how I might achieve this? Any
better ideas on how to accomplish this?

Cheers and thx.