Hi,
I'm trying to figure out how to sort by date and how to group IDs. Essentially, this is for shipping. I want to ship the oldest order but while I am doing that, I might as well ship all the orders for the person with the oldest order.
In the example below, John has the oldest order and 2 other orders, so I want to list him first, with all his orders, and then the next oldest order.
For example, I have:
Date ID Name
6/18/2017 989 John
6/19/2017 456 Sarah
6/20/2017 989 John
6/21/2017 265 Lee
6/22/2017 989 John
6/23/2017 123 Brad
6/24/2017 156 Jessica
This is what I want:
Date ID Name
6/18/2017 989 John
6/20/2017 989 John
6/22/2017 989 John
6/19/2017 456 Sarah
6/21/2017 265 Lee
6/23/2017 123 Brad
6/24/2017 156 Jessica
Any ideas? I'm open to using a macro or pivot table.
Thanks so much!
Rachel
Bookmarks