finding greatest (or least) date associated with given value

Hello, and thanks ahead of time for any assistance.

I am trying to discover a way to look at a table of values with assigned
dates and choose the greatest date for a specific value. For example, value
A has 3 dates assigned (see table below). I would like to be able to find
the greatest date assigned to value A, but ignoring any other dates for other
values, such as value B, value C, etc. Here is a simple table of data:

column a column b
row 1 A 2/5/2003
row 2 A 7/22/2005
row 3 A 5/5/2005
row 4 B 6/1/2002
row 5 B 9/17/2001
row 6 B 1/1/2001

I am hopeful to find a formula that will select 7/22/2005 for greatest date
of value A. Likewise, i'd like to be able to do the same for value B, value
C, etc., as well as find the least date (for example, 2/5/2003 for value A).

Thanks again for any help.
--
Sprocideon

-To conquer without risk is to triumph without glory- El Cid

=MAX((B1:B6)*(A1:A6="A"))
Array formula, to be validated with Ctrl+Shift+Enter

HTH
--
AP

"sprocideon" <[email protected]> a écrit dans le message
de news: [email protected]...
> Hello, and thanks ahead of time for any assistance.
>
> I am trying to discover a way to look at a table of values with assigned
> dates and choose the greatest date for a specific value. For example,
> value
> A has 3 dates assigned (see table below). I would like to be able to find
> the greatest date assigned to value A, but ignoring any other dates for
> other
> values, such as value B, value C, etc. Here is a simple table of data:
>
> column a column b
> row 1 A 2/5/2003
> row 2 A 7/22/2005
> row 3 A 5/5/2005
> row 4 B 6/1/2002
> row 5 B 9/17/2001
> row 6 B 1/1/2001
>
> I am hopeful to find a formula that will select 7/22/2005 for greatest
> date
> of value A. Likewise, i'd like to be able to do the same for value B,
> value
> C, etc., as well as find the least date (for example, 2/5/2003 for value
> A).
>
> Thanks again for any help.
> --
> Sprocideon
>
> -To conquer without risk is to triumph without glory- El Cid

Perfect! Thank you very much.
--
Sprocideon

-To conquer without risk is to triumph without glory- El Cid


"Ardus Petus" wrote:

> =MAX((B1:B6)*(A1:A6="A"))
> Array formula, to be validated with Ctrl+Shift+Enter
>
> HTH
> --
> AP
>
> "sprocideon" <[email protected]> a écrit dans le message
> de news: [email protected]...
> > Hello, and thanks ahead of time for any assistance.
> >
> > I am trying to discover a way to look at a table of values with assigned
> > dates and choose the greatest date for a specific value. For example,
> > value
> > A has 3 dates assigned (see table below). I would like to be able to find
> > the greatest date assigned to value A, but ignoring any other dates for
> > other
> > values, such as value B, value C, etc. Here is a simple table of data:
> >
> > column a column b
> > row 1 A 2/5/2003
> > row 2 A 7/22/2005
> > row 3 A 5/5/2005
> > row 4 B 6/1/2002
> > row 5 B 9/17/2001
> > row 6 B 1/1/2001
> >
> > I am hopeful to find a formula that will select 7/22/2005 for greatest
> > date
> > of value A. Likewise, i'd like to be able to do the same for value B,
> > value
> > C, etc., as well as find the least date (for example, 2/5/2003 for value
> > A).
> >
> > Thanks again for any help.
> > --
> > Sprocideon
> >
> > -To conquer without risk is to triumph without glory- El Cid
>
>
>