I have a sheet with a list of names (A), followed by a cell (B) which contains one or more years separated by commas.
I want to generate a list of all names from A when B contains the number in D:
<tbody>
A
B
C
D
E
John Doe
1998, 2005, 2014
2005
John Doe
Jane Doe
2012, 2014, 2017...