Okay, excel gurus €“ Im wondering if theres any way for excel 02 to return
conditional min and max values and then calculate the difference -- heres
what I have (a small sample of a much larger table imported from a SQL
database):

IRB delivered verdict difference
15781 ?? 26-Jan-06 38743
16746 18-Jan-06 18-Jan-06 0
17127 6-Feb-06 23-Feb-06 17
17127 9-Mar-06 7-Apr-06 29
17127 17-Apr-06 18-Apr-06 1
17692 28-Mar-06 2-May-06 35
18240 15-Feb-06 23-Feb-06 8
18240 13-Mar-06 30-Mar-06 17
18468 8-Feb-06 23-Feb-06 15
18468 4-Oct-06 24-Oct-06 20

Im trying to come up with a way to extract the earliest date in the
€œdelivered€� column and the latest date in the €œverdict€� column for any given
IRB number. If the same number has multiple entries (rows), I then need to
know the absolute earliest and latest dates (and the absolute difference)
over all relevant rows.

From there, I think i can calculate all sorts of useful things, and make
pretty charts and graphs.

Any ideas?

There can be an unlimited number of rows with the same IRB number, if it
matters.

Also, I will eventually be sorting the difference into 15-day sections,
which I'm currently doing with the following kludgy formula and a series of
"countif"s:
=IF(C:C<=15,"<15",(IF(C:C<=30,"<30",(IF(C:C<=45,"< 45",(IF(C:C<=60,"<60","60")))))))

elegant, it's not; suggestions for this part would be most helpful, too....

thanks in advance.