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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]John Doe[/TD]
[TD]1998, 2005, 2014[/TD]
[TD][/TD]
[TD]2005[/TD]
[TD]John Doe[/TD]
[/TR]
[TR]
[TD]Jane Doe[/TD]
[TD]2012, 2014, 2017[/TD]
[TD][/TD]
[TD][/TD]
[TD]George Spelvin[/TD]
[/TR]
[TR]
[TD]George Spelvin[/TD]
[TD]2005, 2012, 2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2012[/TD]
[TD]Jane Doe[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]George Spelvin[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]John Doe[/TD]
[TD]1998, 2005, 2014[/TD]
[TD][/TD]
[TD]2005[/TD]
[TD]John Doe[/TD]
[/TR]
[TR]
[TD]Jane Doe[/TD]
[TD]2012, 2014, 2017[/TD]
[TD][/TD]
[TD][/TD]
[TD]George Spelvin[/TD]
[/TR]
[TR]
[TD]George Spelvin[/TD]
[TD]2005, 2012, 2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2012[/TD]
[TD]Jane Doe[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]George Spelvin[/TD]
[/TR]
</tbody>[/TABLE]
I suspect this is possible using INDEX and MATCH, or INDEX and COUNT(FIND). Much obliged for any suggestions.