Hi Dashman:

Luckly, date/times compare just like ordinary numbers. So if you have
date/times in column A, then

=MIN(A1:A100) formatted properly will give the earliest date/time
--
Gary's Student - gsnu200839


"Dashman" wrote:

I have a list in which I want to find similar dates and times in a column and
extract the earliest date/time. I have been manually sorting the date/time
column and copying the earlier listing to another area of my workbook. The
format in the cells are in date/time (i.e. 11/21/2006 3:13:55 PM). There are
always hundreds of records to sift through. Is there a combination of
functions and/or VBA that I could use to compare dates/times and extract the
earlier of the same dates.
Thanks in advance for your help.