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.
Cross-posted at https://www.mrexcel.com/board/thread...r-set.1127567/
Bookmarks