I have an Excel worksheet with about 19.000 rows with soil information.
The different soils are characterized by an ID field (column) with different
soil depth.
I would like create a new worksheet, that has only the rows of the upper
most and lowest soil depth for each soil ID.
Here an example:
BEFORE
ID Soil depth
1 0
1 20
1 40
2 0
2 20
2 40

AFTER
ID Soil depth
1 0
1 40
2 0
2 40

Help is very appreciated!

Thanks in advance!
ffcmello