Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003: random (1 to 24) to get 24 results without repeat? | Excel Worksheet Functions | |||
Highlight repeat entries | Excel Discussion (Misc queries) | |||
Repeat Entries | Excel Programming | |||
If I create a random list in Excel, does it repeat numbers? | Excel Worksheet Functions | |||
Repeat Entries | Excel Programming |