Comparing Excel Dates

[Dashman]

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.

 

[Gary''s Student]

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

 

[Dashman]

Gary...

Thanks for the response but this a little bit more complex than that... I
don't want the earliest of all the dates. I want the earliest date/time of
comparable entries. For example I might have 3 records with the same date
but different times. I want to be able to extract the earliest of those 3
date/time entries but I also want to do that at the same time for the entire
list. Those 3 records are some of many records. I should also add that the
date/time entries are based on groups of another field such as a transaction
number. The goal is to extract the earliest date/time of records for the
same transaction number each time that number is repeated. Hope that makes
sense.
Thanks.

 

[Shane Devenshire]

Hi,

why don't you show us a sample of the data and what you want returned.

 

[Dashman]

Shane...

Here is an example..

Status Status Date Job ID Recruiter Original Date Posted
New Record 11/7/2006 11:57 163 Admin ZZ- SR 5/23/2004 19:41
New Record 11/7/2006 11:57 163 Admin ZZ- SR 5/23/2004 19:41
New Record 7/18/2007 15:35 599 Admin ZZ- SR 7/19/2006 8:52
New Record 7/18/2007 15:36 599 Admin ZZ- SR 7/19/2006 8:52
New Record 8/9/2006 14:40 174 Admin ZZ- SR 7/13/2004 12:13
New Record 8/9/2006 14:41 174 Admin ZZ- SR 7/13/2004 12:13

Thanks

 

[Dashman]

Shane...

Here is an example...
Status Status Date Job ID Recruiter Original Date Posted
New Record 11/7/2006 11:57 163 Admin ZZ- SR 5/23/2004 19:41
New Record 11/7/2006 11:57 163 Admin ZZ- SR 5/23/2004 19:41
New Record 7/18/2007 15:35 599 Admin ZZ- SR 7/19/2006 8:52
New Record 7/18/2007 15:36 599 Admin ZZ- SR 7/19/2006 8:52
New Record 8/9/2006 14:40 174 Admin ZZ- SR 7/13/2004 12:13
New Record 8/9/2006 14:41 174 Admin ZZ- SR 7/13/2004 12:13