I been struggling to do this for sometime now.

I have two sheets.

I have one column in the first sheet which has duplicate entries. I want to keep this as it is.

I want to create a new column in the second sheet, which is a copy of the column in the first sheet, but without the duplicate entries.

I want to do all this using formulas and not macros, because I want the second sheet to update, as and when new entries are made in the first sheet.

Also ideally I want the formula to apply to the entire column i.e for the 1048576 rows.

To further illustrate:

Sheet 1 has column A which has the following entries

Apple
Orange
Apple
Grape
Tomato
Orange

Sheet 2 should have the column A without the duplicates in column A of Sheet 1, which is:

Apple
Orange
Grape
Tomato

Thank you very much in advance, for taking the time to help me out.