Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
keep rows with most recent date
In my database, each row corresponds to a new purchase or ammended purchase.
The key fields a purchase number purchase linenumber date description amount When a purchase is fist entered, it is given a purchase number and linenumber which never vary, plus a date, description and amount. Later, if someone changes their mind, a new entry will be made with the same purchase number and linenumber, but the description or amount will be different. I want to keep only the rows that have a given purchase number and linenumber but with the most recent date. -- Richard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color Code Date Rows | Excel Worksheet Functions | |||
Finding most recent date by customer number | Excel Worksheet Functions | |||
Date formulas | Excel Discussion (Misc queries) | |||
date function to find most recent order | Excel Worksheet Functions | |||
Insert rows | Excel Worksheet Functions |