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

Question

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

martin_weiss · Answer

Hi&nbsp;JAYMEG&nbsp;&nbsp;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)

Forum Discussion

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

1 Reply