I have column A that is my file number, column B is a date of a transaction. I have duplicate file numbers due to there being multiple transactions from the date ranges I needed. How would I get the most recent date for each file number and delete the duplicates that are older transaction dates. I just need to keep 1 file number but it has to be the most recent transaction date. Thank you!