Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |