Hello,

Thanks in advance for the help.

In column A I have drivers names listed, their names are listed multiple
times. In column B I have odometer reading from each time they fill up with
gas. So the sheet will look like this:

NELSON 16977
PIN 13484
COED 20180
KING 44480
VAN 57243
COED 20790
COED 20419
NELSON 17280
ANGELL 13920
POGG 8266
GILLES 17254
KING 44611

On another sheet I have the drivers names listed in column A (their names
are only listed once on this sheet. In column B I would like a formula that
will match the name and return the odometer's min number and in column C
return the odometer's max number.

I appreciate the help. Thank you very much.

Jim