hi,
use formulas. Max and Min

=MAX(A1:A2000) and =MIN(A1:A2000)

Adjust the the range to fit your data.

Regards
FSt1

"Dwain A, louisiana" wrote:

I have a large equipment database containing the equipment ID, the
odometer/hour reading, and the date it was taken. The list contains multiple
entries for each piece of equipment. I wish to sort through the list and
extract the lowest odometer/hour reading and extract the highest
odometer/hour reading for each piece of equipment. Any assistantance will be
appreciated.