Hello, I have a fair size monthly data table as per the attached sample I could use a bit of help with.
Using one of Mynda's MOTH Oct 28,2020, I was able to create a custom column for the month as per the sample.
I want to extract all the rows that contain 3 in the month column to a separate worksheet.
I posed this question to the AI-formula editor and got this response:
= Filter(A:B,
Month(B:B)
=3)
I am not clear how to apply this to the attached sample. Can someone assist?
Thanks. Ivan
Hi Ivan,
Nothing is attached.
After you select the file click Start Upload to upload it.
Phil
I had received a strange error when I submitted. I was not sure if attachment had been included. Hopefully there now.
Format Column C as a number. In your file it is general.
Please have a look at the attached file, being yours with a spreadsheet formula added that does what you asked for. Thus, it's not done in Power Query, even though you posted your question in that section of the forum.
Thank you.
My main table was formatted/indexed using Power Query so I had assumed I would continue with that.
