avanced filtering for latest date

[Joop]

Hi, I have a question on (advanced) filtering of my database.

The database comprises of rows, each row representing an entry of the
database. Of some entries, the fields are indentical except for the
date field. Example:

Name value Vcc date
gain 3.2 2.7 3 jan 2005
gain 3.5 2.7 5 jan 2005
gain 4.0 3.0 5 jan 2005
ip3 -3 3.0 5 jan 2005


Now I want to filter the value for the "gain" at Vcc=2.7. I can do
that, but then I get to values: 3.2 and 3.5. How can I set up advanced
filtering to give me the latest value (the one at 5 jan 2005)?

Regards,
Joop

 

[Jason Morin]

Use $J$8:$J$9 in the criteria range of the advanced
filter, where J8 is empty and J9 contains:

=AND(A2="gain",C2=2.7,D2=MAX(D))

HTH
Jason
Atlanta, GA

 

[Joop]

Thank you Jason!
This is what I was looking for!

Regards
Joop