formula help

[Newberry]

I have a list of data and I am trying to figure out how to solve the
following,
1 column shows age in days, oldest to youngest, another column contains
codes DC0 through CD9.
How can I show in another cell the oldest age of any particular code i.e.
code DC2 is 365 days.
Thanks for any help or pointers
Newberry

 

[Roger Govier]

Hi
With Days in column A and Codes in column B, enter in C1 the required
code and in D1

{=MAX(($B$1:$B$100=$C1)*($A$1:$A$100))}

This is an array formula, so commit or Edit with Control + Shift + Enter
(CSE) not just Enter.
Do not type the curly braces { } yourself, if you use CSE Excel will
insert them for you.

Enter other codes required in C2, C3 etc. and copy the formula down
column D accordingly.
Change ranges of A and B to suit the amount of data you have.

 

[Guest]

=SUMPRODUCT(MAX((B2:B100="DC2")*(A2:A100)))