Forum Discussion
calof1
Jun 24, 2019Iron Contributor
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 ...
- Jun 25, 2019
Wyn Hopkins
Jun 24, 2019MVP
HI, the attachment didn't come through. Have you used Power Query at all? Sounds ideal for that sort of thing
- calof1Jun 24, 2019Iron Contributor
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,
- Wyn HopkinsJun 25, 2019MVP
- calof1Jun 25, 2019Iron Contributor
Looks great. Will work well for my needs.
Thanks again for your help, much appreciated.