Hi all,

I have a spreadsheet with 2 sheets as follows:

Sheet 1 - Cases Overview
Sheet 2 - Cases

On sheet 2 there are multiple columns of data but Im only interested in the 1st column which contains names.
On sheet 1 I want to produce a list of names that appear in sheet 2, however the names column can contain the same names. But I only need to produce them once on sheet 2.

Sheet 1

Names
name1
name2

Sheet 2

Names
name1
name1
name2
name1
name2

Hope that makes sense?

Cheers