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 ...
HI, the attachment didn't come through. Have you used Power Query at all? Sounds ideal for that sort of thing
Thanks for the message. I have reuattached the spreadsheet, so please let me know if any issues.
Unfortunately i have never used power query before, but keen to learn.
Thank you,
Looks great. Will work well for my needs.
Thanks again for your help, much appreciated.