AllyJM
New member
- Joined
- Jun 9, 2015
- Messages
- 4
- Reaction score
- 0
- Points
- 0
- Location
- Ayrshire, Scotland
- Excel Version(s)
- 2003,2007
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.