ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   keep rows with most recent date (https://www.excelbanter.com/excel-discussion-misc-queries/121388-keep-rows-most-recent-date.html)

Richard

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


All times are GMT +1. The time now is 08:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com