LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Joop
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date updates from worksheet to chart & changes date to a date series! Help!! Jayjg Charts and Charting in Excel 2 January 22nd 05 03:00 PM
Date issue between Windows and Macintosh version dlg1967 Excel Discussion (Misc queries) 4 January 19th 05 03:51 PM
Need help troubleshooting an array formula XLXP on Win2K KR Excel Worksheet Functions 1 December 13th 04 07:41 PM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 02:06 AM
Using formulas to determine date in one cell based on date in anot Gary Excel Worksheet Functions 2 November 22nd 04 08:11 AM


All times are GMT +1. The time now is 12:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"