Hi,
Is there a way to create a list pulling names from another sheet that includes a certain date range?
Using this data below:
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]Madison
[/TD]
[TD]1/16/17[/TD]
[TD]2/3/17[/TD]
[TD]5/15/17[/TD]
[TD]6/2/17[/TD]
[/TR]
[TR]
[TD]Tony[/TD]
[TD]1/18/17[/TD]
[TD]2/5/17[/TD]
[TD]5/30/17[/TD]
[TD]6/17/17[/TD]
[/TR]
[TR]
[TD]Tiffany[/TD]
[TD]2/20/17[/TD]
[TD]3/5/17[/TD]
[TD]5/23/17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Claire[/TD]
[TD]2/26/17
[/TD]
[TD]3/6/17[/TD]
[TD]4/28/17[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Creating a list that includes names with dates between 5/1/17 - 6/30/17 below:
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[/TR]
[TR]
[TD]Madison
[/TD]
[/TR]
[TR]
[TD]Tony[/TD]
[/TR]
[TR]
[TD]Tiffany[/TD]
[/TR]
</tbody>[/TABLE]
Appreciate any help!
Is there a way to create a list pulling names from another sheet that includes a certain date range?
Using this data below:
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]Madison
[/TD]
[TD]1/16/17[/TD]
[TD]2/3/17[/TD]
[TD]5/15/17[/TD]
[TD]6/2/17[/TD]
[/TR]
[TR]
[TD]Tony[/TD]
[TD]1/18/17[/TD]
[TD]2/5/17[/TD]
[TD]5/30/17[/TD]
[TD]6/17/17[/TD]
[/TR]
[TR]
[TD]Tiffany[/TD]
[TD]2/20/17[/TD]
[TD]3/5/17[/TD]
[TD]5/23/17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Claire[/TD]
[TD]2/26/17
[/TD]
[TD]3/6/17[/TD]
[TD]4/28/17[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Creating a list that includes names with dates between 5/1/17 - 6/30/17 below:
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[/TR]
[TR]
[TD]Madison
[/TD]
[/TR]
[TR]
[TD]Tony[/TD]
[/TR]
[TR]
[TD]Tiffany[/TD]
[/TR]
</tbody>[/TABLE]
Appreciate any help!