Locating newest entry

  • Thread starter Thread starter Jan Kronsell
  • Start date Start date
J

Jan Kronsell

I have two columns. In Columns A I have dates and in column B I have values.

It might something like this:

12-02-2008 34
13-02-2008 37
14-02-2008 38
15-02-2008 37
16-02-2008 34
17-02-2008 33
18-02-2008 37
19-02-2008 33
20-02-2008 36
21-02-2008 35
22-02-2008 34


I want to find the date of the latest enrty of the value 34, in this example
22-02-2008. I have tried different combinations of MATCH and INDEX as
formulas and array formulas. Also tried combinations like this
=SUMPRODUCT((MAX(A1:A11)*(B1:B11=34)) but so far with no luck.

Jan
 
Jan,

Array enter (Enter using Ctrl-Shift-Enter)

=MAX(IF(B1:B10=34,A1:A10))

HTH,
Bernie
MS Excel MVP
 
If latest means the one furthest down the rows:

=LOOKUP(2,1/(B1:B11=34),A1:A11)
(remember to format the cell as date)
 
Thank you. Both solutions works fine.

Jan

Dave said:
If latest means the one furthest down the rows:

=LOOKUP(2,1/(B1:B11=34),A1:A11)
(remember to format the cell as date)
Click to expand...
 
Back
Top