avanced filtering for latest date
 

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

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:D))

HTH
Jason
Atlanta, GA

-----Original Message-----
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

.

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

Regards
Joop