I've created a simple text filter:
=IFERROR(REGEXEXTRACT(A1;"- May 2019| - Jun 2019|- Jul 2019| - Aug 2019|- Sep 2019"); FALSE)
It should extract the month and year for an event from the cell A1. A1 contains a lot of text.
It works, but there's a problem: this filter grabs the first match while there can be several events described in A1. What is the proper way to request the last REGEXEXTRACT
match from a string?
A1
. It makes no sense to talk without an example.