Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
Thank you Jason!
This is what I was looking for! Regards Joop |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |