Excel sort dates to be in oldest to newest without changing grouping

I have a list of customers with due dates and corresponding payment dates but the payment dates weren't updated in the correct order. Is there a way I can sort the payment date to be in order without changing the order of the customer and their original due dates? Either thru a look up that can get the dates in order or thru a macro. I've tried using a large on index match but was unsuccessful. Any help would be great!

Data set looks like this

CUSTOMER, DUE DATE, PAYMENT DATE

Toni,     1-Jan 17, 17-Mar-17
Toni,    16-Jan 17,  2-Mar-17
Toni,    31-Jan-17,  1-Jan-17
Toni,    15-Feb-17,  1-Apr-17
Rr,       7-Jan-17, 15-Feb-17
Rr,      22-Jan-17, 16-Jan-17
Rr,       6-Feb-17, 31-Jan-17

End result should look like this

CUSTOMER, DUE DATE, PAYMENT DATE
Toni,     1-Jan 17,  1-Jan-17
Toni ,   16-Jan 17,  2-Mar-17
Toni ,   31-Jan-17, 17-Mar-17
Toni ,   15-Feb-17,  1-Apr-17
Rr,       7-Jan-17, 16-Jan-17
Rr,      22-Jan-17, 31-Jan-17
Rr,       6-Feb-17, 15-Feb-17

Apologies in advance for the poor formatting as I'm still new.

Bella

Posted 2017-10-02T12:03:02.093

Reputation: 1

Possible duplicate of Sort column B while keeping column A's order

– G-Man Says 'Reinstate Monica' – 2017-11-24T22:35:00.767

Answers

I think your 'after' is wrong based on your question, but I have answered with what I think you're trying to get to.

You need to highlight the column with your incorrect dates in, go to the Data tab on the ribbon and sort A>Z, and at the 'Sort Warning' dialog select 'Continue with the current selection'

The result will be that the data in columns A and B will remain as they are now, and column C will be re-ordered.

spikey_richie

Posted 2017-10-02T12:03:02.093

Reputation: 2 497

Hi, yes understand that I can do that manually per group but is there a way to do it by bulk as in my database I have 2k plus groups. Thanks! – Bella – 2017-10-03T04:57:18.063

1select header row > goto data, filter > click on any drop down selection , sort by color, custom filter > set the sorting/grouping criteria. > Done. ( : – p._phidot_ – 2018-08-09T10:23:01.513

@Spikey_Richie's answer above looks mostly correct, although you'll need to do this in groups for each user above.

I suspect the way that this has come about is by doing a sort with Autofilter set up, but not including the final column.

I would suggest going back to the original data (pre-sorting) and re-sort it, making sure that the whole set is ordered.

As it stands, the only way we can know what the correct value for the final column is, is by the fact that you've told us in the question. There would be no way of us knowing this (for sure) otherwise. We would have to make assumptions that may or may not be true.

ro͢binmckenzie

Posted 2017-10-02T12:03:02.093

Reputation: 43

Hi, it needs to be that per person / group, the dates need to be in chronological order. I've tried the custom sort w/ 2 levels but it doesn't because even after sorting the paid date column then sorting the due date column it just goes back to the original data set. Thanks! – Bella – 2017-10-03T05:03:52.063