Formula to extract a sub-set of dates from a larger set

[AllyJM]

I have a worksheet with a list of dates and events in range F2:G19. I want to use a formula to compare the month in cell A2, and the year in cell B2, and go through all the cells in range F2:F19 and extract each and all corresponding dates and place them in the range A5:A7. This is obviously a very simple matter using VBA, but I want to be able to use it on my Android phone, which will not run macros.

 

[jasonb75]

Perhaps

=IFERROR(AGGREGATE(15,6,$F$2:$F$19/(TEXT($F$2:$F$19,"mmm")=$A$2)/(YEAR($F$2:$F$19)=$B$2),ROWS($A$5:$A5)),"")

Assumed abbreviated months in text format, i.e. Jan, Feb, Mar, etc. You might need to array confirm the formula, which I don't think can be done on Android, in which case you would need to apply the formula in desktop excel, then transfer the file.

 

[Fluff]

Cross posted Formula to extract a sub-set of dates from a larger set

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Fluff]

@AllyJM
Please also supply links to any other sites you have asked this question. Thanks