Hello

I have a list of 40,000 records.

The records are grouped by a receipt number, a receipt date, and time stamp.
So, for example, there can be 10 records with the same receipt number, 4
different dates, with each record having a time stamp. Now the list is
sorted in the following order - Receipt Number, Date, Time Stamp. What I am
attempting to accomplish is to identify the last record in each record set
based on the most recent date,and ifmore than one date then the latest time
stamp. How would I accomplish this using Excel?

Thank you.

Mark :)