I have an array formula that pulls out lines of information based on when invoices have been paid into our account on a weekly basis, and It works fine However, as the invoices are not paid in the order they were added, the results are therefore in the same order - with maybe a Weds payment showing before a Monday etc.
I've attached a simplified copy file of what I currently have.
Sales Book - example.xlsm
Is there any way to make the results on the 'Cash Postings' tab show in numerical order based on the date in column A, so that all the rest of the data in the following columns are correct? I cannot re-order anything on the main tab, it has to be as it is currently set out. I can make any helper columns though from AZ->
Thanks in advance.
Bookmarks