Forum Discussion
Solved
Sort data by categories between certain dates.
Hi, I have a large amount of data which involves categories and transaction. I would like to find a formula which will automatically find the relevant information between certain date periods. I ...
As Wyn Hopkins said, Power Query is a great option and can be easily refreshed to include new data.
If you have Office 365 then my preference will be to Dynamic Arrays SortBy function.
Good Luck
Nabil Mourad
Thank you for the message.
As i have never used the DynamicArrays sort before, are you able to provide an example?
Many thanks,