index matching and removing duplicates

[chubbster31]

Hi, I can't attach my spreadsheet for some reason otherwise I would but I've shown a photo of an example.

excel photo 2.PNG

In the example, if i choose a date range, e.g. 07/01/2016 to 08/02/2016, I want to create a column list displaying the names in this range but not duplicated. So the result would look like this

excel photo 3.PNG

I have no idea if this is possible, but thanks

[Olly]

Edit: thread title corrected, thanks.

[Special-K]

To attach a file click Go Advanced then click the paper clip on the right of the yellow smiley face.

[chubbster31]

yeah I tried but the drop down doesn't let me add anything, its blank

[Olly]

The quickest and easiest way would be to use a pivot table.

[AlKey]

Here is formula solution.
I couldn't type the whole data set by hand so here is a small sample which should work fine once you apply it to your table.
**I have placed the Start date in cell E4 and End date in F4
Enter formula in cell E5 and copy down

Please Login or Register  to view this content.

v	C	D	E	F
1
2
3			Start	End
4	Name	Date	7/1/2016	8/2/2016
5	Brian	1/7/2016	Conor
6	Steve	2/16/2016	Ben
7	Conor	8/1/2016	Paul
8	Ben	7/8/2016	Casper
9	Paul	7/25/2016
10	Brian	6/10/2016
11	Tim	2/15/2015
12	Casper	7/5/2016
13	Alex	2/4/2016
14	Paul	2/3/2016
15	Ben	8/1/2016
16	Geoff	9/14/2016
17