Sort Data By Multiple Date Columns as 1st Priority (Invoice Date & Payment Date)

Regular Visitor

In an excel spreadsheet I want to sort data as normal but want it to sort the date using 2 different columns where only one has a date filled out (in this case each transaction creates 2 rows/entries one column has invoice date and another for payment date (debit/credit), currently when I sort it shows all the invoices in a row then payments in a row but I want them to be sorted interchanged so I can follow the invoices/payments in proper order.

 

I appreciate your help

1 Reply

Hi @JAYMEG 

 

you could create a helper column which says D or C (debit or credit) depending on the type of record. And then you could sort by your date field (first sort criteria) and the helper column (second criteria)