Captain McFunk
New Member
- Joined
- Dec 12, 2016
- Messages
- 7
Hey all, I had this answered last week that I could reference back to but it appears it was wiped out wit the db attack, so i'm posting again, i apologize for having to have it answered twice!
I have a list of patients that have multiple orders listed by date. I'm trying to find what is the most recent order date and corresponding row data for every customer id#. My table looks a little like this:
<tbody>
</tbody>
I'm needing to be able to identify and filter to show just the rows for each customerid that have the most recent order date. I remember the solution having something to do with a countifs statement, but i tried a couple of times and couldn't get there. I would greatly appreciate some help!!!
I have a list of patients that have multiple orders listed by date. I'm trying to find what is the most recent order date and corresponding row data for every customer id#. My table looks a little like this:
CustomerID | OrderDate | |
12345 | 10/25/16 | |
12345 | 11/25/16 | |
12345 | 12/25/16 | |
67891 | 9/25/16 | |
67891 | 10/25/16 | |
67891 | 11/25/16 | |
67891 | 12/25/16 |
<tbody>
</tbody>
I'm needing to be able to identify and filter to show just the rows for each customerid that have the most recent order date. I remember the solution having something to do with a countifs statement, but i tried a couple of times and couldn't get there. I would greatly appreciate some help!!!