jnelson522
New Member
- Joined
- Oct 30, 2017
- Messages
- 7
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>
</tbody>
I suspect this is possible using INDEX and MATCH, or INDEX and COUNT(FIND). Much obliged for any suggestions.
I want to generate a list of all names from A when B contains the number in D:
A | B | C | D | E |
John Doe | 1998, 2005, 2014 | 2005 | John Doe | |
Jane Doe | 2012, 2014, 2017 | George Spelvin | ||
George Spelvin | 2005, 2012, 2017 | |||
2012 | Jane Doe | |||
George Spelvin |
<tbody>
</tbody>
I suspect this is possible using INDEX and MATCH, or INDEX and COUNT(FIND). Much obliged for any suggestions.