Return the smallest value
 

I have a database of information

Col A Col B Col C
Name Start Time Earliest Start?

Column A and B return information from elsewhere and i would like column C
to return the value from column B that represents the earliest start time
for the person in column A. The person in Col A may appear several times but
I need Col C only to return thier earliest start time.

Thanks

Homework?

--
Don Guillett
SalesAid Software

"Donkey" wrote in message
...
I have a database of information

Col A Col B Col C
Name Start Time Earliest Start?

Column A and B return information from elsewhere and i would like column C
to return the value from column B that represents the earliest start time
for the person in column A. The person in Col A may appear several times
but
I need Col C only to return thier earliest start time.

Thanks

Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany

Donkey wrote:
I have a database of information

Col A Col B Col C
Name Start Time Earliest Start?

Column A and B return information from elsewhere and i would like
column C to return the value from column B that represents the
earliest start time for the person in column A. The person in Col A
may appear several times but I need Col C only to return thier
earliest start time.
Thanks