Hi,

I have a large file consisting of data sampled every 10 cm for a series of zones . I would like to write a VB script to read the file and then record only the shallowest and deepest data for each zone. e.g.
Original file
Name Top_Depth Bottom_Depth Zone Source
Alkine 1003 1013 XP KLM
Alkine 1023 1033 XP KLM
Alkine 1043 1053 XP KLM
Alkine 1063 1073 XP KLM
Alkine 1083 1093 XP KLM
Alkine 1103 1113 XP KLM
Ahyune 1123 1133 ZP DLK
Ahyune 1133 1143 ZP DLK
Ahyune 1153 1163 ZP DLK

Final result should look like this.

Name Top_Depth Bottom_Depth Zone Source
Alkine 1003 1113 XP KLM
Ahyune 1123 1163 ZP DLK

Thank you

Raury