Forum Discussion
Sort Data By Multiple Date Columns as 1st Priority (Invoice Date & Payment Date)
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...
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)